From: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
---|---|
To: | Kirk Wolak <wolakk(at)gmail(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Subject: | Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [Fixed Already] |
Date: | 2024-01-16 08:43:50 |
Message-ID: | 8B7A0B6B-7D20-4096-A0AD-926AC19DAA6C@yesql.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> On 16 Jan 2024, at 02:53, Kirk Wolak <wolakk(at)gmail(dot)com> wrote:
>
> On Mon, Jan 15, 2024 at 9:03 AM Daniel Gustafsson <daniel(at)yesql(dot)se <mailto:daniel(at)yesql(dot)se>> wrote:
> > On 15 Jan 2024, at 07:24, Kirk Wolak <wolakk(at)gmail(dot)com <mailto:wolakk(at)gmail(dot)com>> wrote:
>
> > You have a commit [1] that MIGHT fix this.
> > I have a script that recreates the problem, using random data in pg_temp.
> > And a nested cursor.
>
> Running your reproducer script in a tight loop for a fair bit of time on the
> v16 HEAD I cannot see any memory growth, so it's plausible that the upcoming
> 16.2 will work better in your environment.
>
> Okay, I took the latest source off of git (17devel) and got it to work there in a VM.
>
> It appears this issue is fixed. It must have been related to the issue originally tagged.
Thanks for testing and confirming! Testing pre-release builds on real life
workloads is invaluable for the development of Postgres so thank you taking the
time.
--
Daniel Gustafsson
From | Date | Subject | |
---|---|---|---|
Next Message | Li, Yong | 2024-01-16 09:12:16 | Re: Proposal to add page headers to SLRU pages |
Previous Message | Bertrand Drouvot | 2024-01-16 08:42:11 | Re: Synchronizing slots from primary to standby |