Re: ReadRecentBuffer() doesn't scale well

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, pgsql-hackers(at)postgresql(dot)org, Ants Aasma <ants(at)cybertec(dot)at>
Subject: Re: ReadRecentBuffer() doesn't scale well
Date: 2025-10-08 00:39:14
Message-ID: CA+hUKGLRa7b95u-vcd1vkjcjEYu-PrZD9f6pSP-ny6XqtA1a0w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Sep 19, 2025 at 11:44 AM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> On Fri, Sep 19, 2025 at 12:36 AM Andres Freund <andres(at)anarazel(dot)de> wrote:
> > I'm planning to commit 0001 soon, unless you'd like to do the honors - I would
> > break it with some upcoming patches, and it's a good improvement. Those
> > patches also will PinBuffer_Locked() a bit slower, i.e. it'd be good to avoid
> > using it in ReadRecentBuffer() for that reason alone.
>
> Oh, thanks for thinking about that interaction. I'll go ahead and
> push it later today after I re-convince myself that it's correct.

Sorry I haven't got to this yet. Please feel free to go ahead and
push it if it's blocking you...

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2025-10-08 00:45:37 Re: Questionable result from lead(0) IGNORE NULLS
Previous Message Tatsuo Ishii 2025-10-08 00:31:17 Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options