Re: [BUGS] json(b)_array_elements use causes very large memory usage when also referencing entire json document

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] json(b)_array_elements use causes very large memory usage when also referencing entire json document
Дата
Msg-id 5827.1507320802@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] json(b)_array_elements use causes very large memory usagewhen also referencing entire json document  (Lucas Fairchild-Madar <lucas.madar@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
Lucas Fairchild-Madar <lucas.madar@gmail.com> writes:
> Is there any sort of setting right now that can defend against this? A way
> to prevent a query from using 20+GB of memory? I'd prefer the query fail
> before the database system is kill -9'd.

You could experiment with running the postmaster under a ulimit setting,
but the more traditional recommendation is to disable OOM kill, cf

https://www.postgresql.org/docs/current/static/kernel-resources.html#linux-memory-overcommit
        regards, tom lane


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Lucas Fairchild-Madar
Дата:
Сообщение: Re: [BUGS] json(b)_array_elements use causes very large memory usagewhen also referencing entire json document
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql