Re: Add CHECK_FOR_INTERRUPTS in pg_buffercache_pages while scanning the buffers

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add CHECK_FOR_INTERRUPTS in pg_buffercache_pages while scanning the buffers
Date: 2025-08-15 19:03:41
Message-ID: CAD21AoBEYh2QuDh1npf3f6AXCumKQx7VJ2s4B=UC0vz=dcrHMA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 15, 2025 at 2:33 AM SATYANARAYANA NARLAPURAM
<satyanarlapuram(at)gmail(dot)com> wrote:
>
> Hi Masahiko,
>
> On Thu, Aug 14, 2025 at 4:57 PM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>>
>> On Fri, Aug 8, 2025 at 2:59 PM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>> >
>> > On Thu, Jul 31, 2025 at 4:31 PM SATYANARAYANA NARLAPURAM
>> > <satyanarlapuram(at)gmail(dot)com> wrote:
>> > >
>> > > Please find attached patch that adds CHECK_FOR_INTERRUPTS while scanning the buffers in pg_buffercache_pages. I checked other functions in the module and this check already exists in pg_buffercache_numa_pages.
>> >
>> > Thank you for the patch!
>> >
>> > I think the patch is reasonable and it looks good to me. I'll push it
>> > to master early next week, barring objections.
>>
>> After reviewing this patch more, I'm leaning toward to backpatch this
>> change. The patch adds CHECK_FOR_INTERRUPTS() to
>> pg_buffercache_pages(), pg_buffercache_summary(), and
>> pg_buffercache_usage_counts(), and the latter two functions were
>> introduced in v16. Therefore, for v15 or older we can add CFI to only
>> pg_buffercache_pages() and apply this patch to v16 or newer. Thoughts?
>
>
> Thanks for reviewing the patch. Sounds good to me.

Could you provide patches also for back branches? or shall I?

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2025-08-15 19:25:50 Re: index prefetching
Previous Message Masahiko Sawada 2025-08-15 19:01:14 Re: Fix for typo in UUIDv7 timestamp extraction