Re: Memory leak on subquery as scalar operand

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: lauri(dot)laanmets(at)eesti(dot)ee
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Memory leak on subquery as scalar operand
Date: 2022-10-31 23:20:38
Message-ID: CAApHDvrSbQkPUacnaonQzw1efFJM6HE5we-i9VVogBfEKGCCiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, 31 Oct 2022 at 23:03, Lauri Laanmets <pcspets(at)gmail(dot)com> wrote:
> There seems to be a memory leak in PostgreSQL for Linux (doesn't happen on Windows). At least in versions 12 to 14 (and not in 9.5). It can be reproduced with the following SQL script on an empty database.
>
> * When repeated, Linux process starts using more and more RAM until OOM-killer will kill it.
> * 'pg_backend_memory_contexts' doesn't show any increase.
> * (gdb) p MemoryContextStats(TopMemoryContext) - doesn't show any increase.

Does it still OOM if you do:

SET jit TO off; ?

David

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-11-01 00:44:09 Re: Memory leak on subquery as scalar operand
Previous Message David Rowley 2022-10-31 20:40:12 Re: Strange sort node/explain result