Postgres Pro
Downloads
Home   >   mailing lists

Re: One PG process eating more than 40GB of RAM and getting killed by OOM - Mailing list pgsql-admin

From Tom Lane
Subject Re: One PG process eating more than 40GB of RAM and getting killed by OOM
Date
Msg-id 1528962.1697209324@sss.pgh.pa.us
Whole thread Raw
In response to Re: One PG process eating more than 40GB of RAM and getting killed by OOM  (Jean-Christophe Boggio <postgresql@thefreecat.org>)
List pgsql-admin
Tree view 
Jean-Christophe Boggio <postgresql@thefreecat.org> writes:
> You can find the corresponding logs attached.

Your query seems to be creating TupleSort contexts and then leaking
them, which is surely a bug.  Can you make a self-contained test
case that reproduces this?

            regards, tom lane

pgsql-admin by date:

Previous
From: Rajesh Kumar
Date:
Subject: Re: Locks analyze
Next
From: Jeff Janes
Date:
Subject: Re: One PG process eating more than 40GB of RAM and getting killed by OOM