Re: ERROR: out of memory DETAIL: Failed on request of size ???

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: ERROR: out of memory DETAIL: Failed on request of size ???
Дата
Msg-id CAGrpgQ9L3knTrgBXHqpLmh+LB8jgkLoTt6Ub87_nGEGH6-07xA@mail.gmail.com
обсуждение исходный текст
Ответ на ERROR: out of memory DETAIL: Failed on request of size ???  (Brian Wong <bwong64@hotmail.com>)
Список pgsql-general
Дерево обсуждения
On Mon, Nov 18, 2013 at 12:40 PM, Brian Wong <bwong64@hotmail.com> wrote:
We'd like to seek out your expertise on postgresql regarding this error that we're getting in an analytical database.

Some specs:
proc: Intel Xeon X5650 @ 2.67Ghz dual procs 6-core, hyperthreading on.
memory: 48GB
OS: Oracle Enterprise Linux 6.3
postgresql version: 9.1.9
shared_buffers: 18GB

After doing a lot of googling, I've tried setting FETCH_COUNT on psql AND/OR setting work_mem.  I'm just not able to work around this issue, unless if I take most of the MAX() functions out but just one.

What is your work_mem set to?
Did testing show that shared_buffers set to 18GB was effective? That seems about 2 to 3 times beyond what you probably want.

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

Предыдущее
От: Brian Wong
Дата:
Сообщение: ERROR: out of memory DETAIL: Failed on request of size ???
Следующее
От: David Johnston
Дата:
Сообщение: Re: Suggestion: pg_dump self-cleanup if out-of-disk