Re: Out of Memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Out of Memory
Дата
Msg-id 3681.1421371129@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Out of Memory  (Enrico Bianchi <enrico.bianchi@ymail.com>)
Ответы Re: Out of Memory  (Enrico Bianchi <enrico.bianchi@ymail.com>)
Список pgsql-general
Enrico Bianchi <enrico.bianchi@ymail.com> writes:
> When I launch a query (the principal field is JSONb), the database
> return this:
> ERROR:  out of memory
> DETAIL:  Failed on request of size 110558.

That error should be associated with a memory usage map getting dumped to
postmaster stderr, where hopefully your logging setup will catch it.
Can we see the map?

Even better would be a self-contained test case.  Maybe you can generate
some artificial data that produces the problem?

            regards, tom lane


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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Need advice for handling big data in postgres
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Proper use of pg_xlog_location_diff()