From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: is there still a memory leak with hash joins in PG 12.11 ? |
Date: | 2022-09-28 11:13:06 |
Message-ID: | 20220928111306.rslbso5vtcjcoilt@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2022-Sep-28, Zwettler Markus (OIZ) wrote:
> I found this blog post talking about a memory leak having hash joins due to a larger work_mem.
> https://gist.github.com/luhn/2b35a9b31255e3a6a2e6a06d1213dfc9
Oh dear, is that what passes for a blog post these days?
> Does anyone know if this problem is still there in PG 12.11 ?
It wasn't there in 9.5, so it seems safe to believe it isn't in 12.11.
> We are running on PG 12.11.
> We recognized an evergrowing memory usage.
>
> work_mem = 50M
> there are some regularly hash joins.
I think it's more likely that this is a new, different bug (assuming it
is a bug at all). But you'd have to provide more details in order to
track it down.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"El Maquinismo fue proscrito so pena de cosquilleo hasta la muerte"
(Ijon Tichy en Viajes, Stanislaw Lem)
From | Date | Subject | |
---|---|---|---|
Next Message | Fabien COELHO | 2022-09-28 13:07:06 | Re: [PATCH] Introduce array_shuffle() and array_sample() |
Previous Message | Martin Kalcher | 2022-09-28 10:40:31 | Re: [PATCH] Introduce array_shuffle() and array_sample() |