From: | Paul Ramsey <pramsey(at)cleverelephant(dot)ca> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Stephan Knauss <pgsql(at)stephans-server(dot)de>, "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:27:26 |
Message-ID: | 32593FA7-5D1C-4AEF-8584-C8F630E7AE8A@cleverelephant.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Mar 31, 2021, at 11:24 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> 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.
Would be interested in the queries being run. We have a reproduceable leak in <-> geography operator that we have been unable to track down.
P
>
> regards, tom lane
>
> [1] https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=eba939551
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Martin | 2021-03-31 19:35:47 | Failed to initialize 13.2-1 cluster on Windows |
Previous Message | Tom Lane | 2021-03-31 18:24:10 | Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1 |