From: | SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com> |
---|---|
To: | Masahiko Sawada <sawada(dot)mshk(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-18 18:59:07 |
Message-ID: | CAHg+QDeHUpmb16DHBSJtidtHNTOqwimE23NDGw-hcxsm1a4Q1Q@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, Aug 15, 2025 at 12:04 PM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
wrote:
> 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?
>
Attached the patch for v15 and below. Please let me know if you need
anything.
Thanks,
Satya
Attachment | Content-Type | Size |
---|---|---|
pg_buffercache_interrupt_check_pg15.patch | application/octet-stream | 513 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Sami Imseih | 2025-08-18 20:10:42 | Re: pg_stat_statements: Add `calls_aborted` counter for tracking query cancellations |
Previous Message | Doruk Yilmaz | 2025-08-18 18:55:19 | Re: [Patch] add new parameter to pg_replication_origin_session_setup |