Re: Postgresql 16.3 Out Of Memory

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Postgresql 16.3 Out Of Memory
Дата
Msg-id CAKAnmm+4RLHrKSyedZ+hTkwedP05+Ldp+bHiD00SuJvgAekRgA@mail.gmail.com
обсуждение исходный текст
Ответ на Postgresql 16.3 Out Of Memory  (Radu Radutiu <rradutiu@gmail.com>)
Ответы Re: Postgresql 16.3 Out Of Memory
Список pgsql-general
On Mon, Jun 3, 2024 at 6:19 AM Radu Radutiu <rradutiu@gmail.com> wrote: 
Do you have any idea how to further debug the problem? 

Putting aside the issue of non-reclaimed memory for now, can you show us the actual query? The explain analyze you provided shows it doing an awful lot of joins and then returning 14+ million rows to the client. Surely the client does not need that many rows?

You can probably also prevent OOM by lowering your work_mem and/or your max_parallel_workers_per_gather.

Cheers,
Greg

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

Предыдущее
От: Radu Radutiu
Дата:
Сообщение: Postgresql 16.3 Out Of Memory
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Postgresql 16.3 Out Of Memory