Re: ReadRecentBuffer() doesn't scale well

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org, Amit Langote <amitlangote09(at)gmail(dot)com>
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:09:54
Message-ID: 6D070023-BC1F-4473-A315-855416C2F8DA@anarazel.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On October 8, 2025 10:05:59 PM EDT, Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
>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.

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.

Greetings,

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2025-10-09 02:12:50 Re: [PATCH] Add tests for Bitmapset
Previous Message Amit Langote 2025-10-09 02:05:59 Re: ReadRecentBuffer() doesn't scale well