Re: ReadRecentBuffer() doesn't scale well

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, 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-09 02:05:59
Message-ID: CA+HiwqGKJ6nEXEPQW7EpykVsEtzxp5-up_xhtcUAkWFtATVQvQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Andres,

On Thu, Oct 9, 2025 at 2:15 AM Andres Freund <andres(at)anarazel(dot)de> wrote:
>
> Hi,
>
> On 2025-10-08 13:39:14 +1300, Thomas Munro wrote:
> > 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...
>
> Done after two small changes:

Perhaps you are on it, but it seems skink is red due to either this or
one of the other bufmgr changes. I noticed it after I pushed a patch
of mine and couldn't see the connection.

postmaster.log suggests a valgrind error.

--
Thanks, Amit Langote

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2025-10-09 02:09:54 Re: ReadRecentBuffer() doesn't scale well
Previous Message Hayato Kuroda (Fujitsu) 2025-10-09 02:05:36 RE: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE