Re: Hash Aggregate plan picked for very large table == out of memory

Поиск
Список
Период
Сортировка
От Mason Hale
Тема Re: Hash Aggregate plan picked for very large table == out of memory
Дата
Msg-id 8bca3aa10706141404g2d45351ci390a76faeb492f04@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Hash Aggregate plan picked for very large table == out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Hash Aggregate plan picked for very large table == out of memory  ("Mason Hale" <masonhale@gmail.com>)
Re: Hash Aggregate plan picked for very large table == out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
Thanks Tom. Here's more info:

What have you got work_mem set to?  

40960

What's the actual number of groups
(target_page_id values)?

Approximately 40 million (I'll have a more precise number when the query finishes running ).

Maybe this helps?

crystal=> select null_frac, n_distinct, correlation from pg_stats where tablename = 'page_page_link' and attname = 'target_page_id';
 null_frac | n_distinct | correlation
-----------+------------+-------------
         0 |     550017 |    0.240603
(1 row)

Mason


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Hash Aggregate plan picked for very large table == out of memory
Следующее
От: "Mason Hale"
Дата:
Сообщение: Re: Hash Aggregate plan picked for very large table == out of memory