Re: Abnormally high memory usage/OOM triggered

Поиск
Список
Период
Сортировка
От scott ribe
Тема Re: Abnormally high memory usage/OOM triggered
Дата
Msg-id 5E0AB8DB-F13B-41BF-843A-FE64FBE9C097@elevated-dev.com
обсуждение исходный текст
Ответ на Abnormally high memory usage/OOM triggered  (Davlet Panech <dpanech@gmail.com>)
Ответы Re: Abnormally high memory usage/OOM triggered  (Davlet Panech <dpanech@gmail.com>)
Список pgsql-admin
On Jan 17, 2018, at 2:57 PM, Davlet Panech <dpanech@gmail.com> wrote:
>
> Does my configuration look reasonable? I just don't understand how it could possibly use up 19 GB of memory based on
theconfiguration below. Is there a memory leak in there somewhere? 

It does seem awfully high, but... An update can involve a join across multiple tables. Or an update can run a trigger
whichcan cascade. Either of those could result in an "accidental cross product" join, which can always blow up memory. 

--
Scott Ribe
https://www.linkedin.com/in/scottribe/
(303) 722-0567



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

Предыдущее
От: Davlet Panech
Дата:
Сообщение: Abnormally high memory usage/OOM triggered
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Abnormally high memory usage/OOM triggered