Hi,
On Fri, Oct 13, 2023 at 03:06:57PM +0200, Jean-Christophe Boggio wrote:
> On my dev laptop, I have ~40GB free RAM. When launching a heavy calculation
> in PostgreSQL (within a stored procedure), it consumes as much memory as is
> available and then gets killed by OOM. There is only one connected session.
>
> I have the following settings, which look reasonable (to me):
>
> shared_buffers = 512MB # min 128kB
That's not a lot.
> work_mem = 1GB # min 64kB
On the other hand, that's a lot. So if that query is run in parallel and
has a lot of different things it does, it might use work_mem several
times over, resulting in a lot of used memory.
So first thing to try would be to lower work_mem to someting much lower
like 64MB or 128MB.
> This is PostgreSQL 14.7 running on Ubuntu 23.04
The other thing you can try is to see whether turning jit off (or just
jit_inline_above_cost = -1) is helping.
Michael