Re: Out of memory error during large hashagg

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Out of memory error during large hashagg
Дата
Msg-id 12436.1159210962@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Out of memory error during large hashagg  (Casey Duncan <casey@pandora.com>)
Список pgsql-bugs
Casey Duncan <casey@pandora.com> writes:
> I haven't tried increasing the stats target. What would be a suitable
> value to try?

Try 100 (instead of the default 10) ... you can go as high as 1000,
though hopefully that's overkill.

            regards, tom lane

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

Предыдущее
От: Casey Duncan
Дата:
Сообщение: Re: Out of memory error during large hashagg
Следующее
От: "Remy Beaumont"
Дата:
Сообщение: BUG #2651: 8.2 - beta 1 does now compile with Sun Studio 11