Re: BUG #19345: MemoryContextSizeFailure after upgrade 14.11 to 17.7 in stored procedure

From: Kirill Reshke <reshkekirill(at)gmail(dot)com>
To: weijie1006jl(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19345: MemoryContextSizeFailure after upgrade 14.11 to 17.7 in stored procedure
Date: 2025-12-05 13:36:27
Message-ID: CALdSSPiJknfFn5rdupB9c7ttrFqDWs3jJPj60=_=-2YpYa27_g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, 5 Dec 2025 at 15:38, PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:

> SET hash_mem_multiplier = 1; → procedure runs successfully.

I think this is because of

https://git.postgresql.org/cgit/postgresql.git/commit/?id=8f388f6f554b113f25a53fe3237238d2c58ed1eb

We have this is release notes https://postgr.es/c/8f388f6f5

So, after upgrading to 17 (and thus, having this change), defaults
changed, some queries now need adjustment... I am not sure we have
fixable problem in HEAD here

--
Best regards,
Kirill Reshke

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2025-12-05 22:17:33 Re: BUG #19340: Wrong result from CORR() function
Previous Message Anthonin Bonnefoy 2025-12-05 13:33:26 Re: Segfault due to NULL ParamExecData value