Re: ReadRecentBuffer() doesn't scale well - Mailing list pgsql-hackers

From Amit Langote
Subject Re: ReadRecentBuffer() doesn't scale well
Date
Msg-id CA+HiwqFwHH+oFwCxdL0i60B7vN5tFudnvabkwBu0gB4q7bgUvQ@mail.gmail.com
Whole thread Raw
In response to Re: ReadRecentBuffer() doesn't scale well  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Sat, Oct 11, 2025 at 1:08 AM Andres Freund <andres@anarazel.de> wrote:
> On 2025-10-08 22:09:54 -0400, Andres Freund wrote:
> > On October 8, 2025 10:05:59 PM EDT, Amit Langote <amitlangote09@gmail.com> wrote:
> > >On Thu, Oct 9, 2025 at 2:15 AM Andres Freund <andres@anarazel.de> wrote:
> > >> On 2025-10-08 13:39:14 +1300, Thomas Munro wrote:
> > >> > On Fri, Sep 19, 2025 at 11:44 AM Thomas Munro <thomas.munro@gmail.com> wrote:
> > >> > > On Fri, Sep 19, 2025 at 12:36 AM Andres Freund <andres@anarazel.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.
> >
> > Yes, I saw it. I'm too tired to figure it out tonight, will look more
> > tomorrow. I think it'll just need to mark the buffer data accessible in one
> > more spot.
>
> To update this thread as well:
> This is fixes as of
> https://git.postgresql.org/pg/commitdiff/c819d1017ddb349d92ab323d2631bc1f10bb4e86
> the change from this thread wasn't to blame, it was 5e899859287.

Thanks a lot for taking care of it.

--
Thanks, Amit Langote



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: ReadRecentBuffer() doesn't scale well
Next
From: Nathan Bossart
Date:
Subject: Re: Clarification on Role Access Rights to Table Indexes