Re: Postgresql 16.3 Out Of Memory - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Postgresql 16.3 Out Of Memory
Date
Msg-id CAKAnmm+4RLHrKSyedZ+hTkwedP05+Ldp+bHiD00SuJvgAekRgA@mail.gmail.com
Whole thread Raw
In response to Postgresql 16.3 Out Of Memory  (Radu Radutiu <rradutiu@gmail.com>)
Responses Re: Postgresql 16.3 Out Of Memory
List 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 by date:

Previous
From: Radu Radutiu
Date:
Subject: Postgresql 16.3 Out Of Memory
Next
From: Ron Johnson
Date:
Subject: Re: Postgresql 16.3 Out Of Memory