Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Knauss <pgsql(at)stephans-server(dot)de>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1
Date: 2021-03-31 18:24:10
Message-ID: 3269480.1617215050@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephan Knauss <pgsql(at)stephans-server(dot)de> writes:
> Hello Tom, the output below looks similar to the OOM output you
> expected. Can you give a hint how to interpret the results?

Looks like the answer is that wherever the leak is, it's not accounted
for by this info; none of those contexts are particularly large.

Based on nearby threads, it occurs to me to ask whether you have JIT
enabled, and if so whether turning it off helps. There seems to be
a known leak of the code fragments generated by that in some cases.

If that's not it, then the leak must be accumulating through plain
old malloc calls. There's not much of that in the core backend
(although if you use ispell text search dictionaries, maybe [1] is
relevant), so my suspicions would next fall on any extensions you
might be using.

regards, tom lane

[1] https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=eba939551

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Ramsey 2021-03-31 18:27:26 Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1
Previous Message Virendra Kumar 2021-03-31 18:15:23 Copy Statistics Tables During Upgrade