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 CAGrpgQ9UGhTyXJ-vKoVd2J5JG4JOBVckEBTnrfJmUXBPNCHwXQ@mail.gmail.com
обсуждение исходный текст
Ответ на ERROR: out of memory DETAIL: Failed on request of size ???  (Brian Wong <bwong64@hotmail.com>)
Ответы Re: ERROR: out of memory DETAIL: Failed on request of size ???
Список pgsql-general
Дерево обсуждения

On Mon, Nov 18, 2013 at 8:30 PM, Brian Wong <bwong64@hotmail.com> wrote:
I've tried any work_mem value from 1gb all the way up to 40gb, with no effect on the error.  I'd like to think of this problem as a server process memory (not the server's buffers) or client process memory issue, primarily because when we tested the error there was no other load whatsoever.  Unfortunately,  the error doesn't say what kinda memory ran out.

I wasn't asking because I thought you should make it higher, I think you should make it lower. Set it to 200MB and reload your conf files ("select pg_reload_conf()") and try your queries again. work_mem is a per step setting, used by aggregates and sort steps, potentially multiple times in a single query, also multiplied by any other concurrent queries. In this case, it might not be the cause, but certainly try a lower setting to rule it out.

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

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: Suggestion: pg_dump self-cleanup if out-of-disk
Следующее
От: gajendra s v
Дата:
Сообщение: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml