Re: Add pg_buffercache_mark_dirty[_all] functions to the pg_buffercache - Mailing list pgsql-hackers

From Nazir Bilal Yavuz
Subject Re: Add pg_buffercache_mark_dirty[_all] functions to the pg_buffercache
Date
Msg-id CAN55FZ1S_e32YoKjeA9rco7+a9RpaB4vrFQJZfjXTu=JoiVJ3w@mail.gmail.com
Whole thread Raw
In response to Re: Add pg_buffercache_mark_dirty[_all] functions to the pg_buffercache  (邱宇航 <iamqyh@gmail.com>)
List pgsql-hackers
Hi,

On Thu, 27 Nov 2025 at 05:51, 邱宇航 <iamqyh@gmail.com> wrote:
>
> > I do not think that will be a problem but I can change it if the
> > general consensus is towards this way. Also, if we change this for
> > pg_buffercache_mark_dirty_* functions, I think we need to apply the
> > same for the pg_buffercache_evict_* functions.
>
> After some testing, bgwriter/checkpointer didn' blocks the mark buffer
> dirty SQL. it's ok to use LWLockAcquire.

Thanks for testing this!

> There is an extra line break after elog(ERROR, "bad buffer ID: %d", buf)
> which can be removed.

Done in the v10. I wonder why pgindent did not catch this.

--
Regards,
Nazir Bilal Yavuz
Microsoft



pgsql-hackers by date:

Previous
From: Nazir Bilal Yavuz
Date:
Subject: Re: Add pg_buffercache_mark_dirty[_all] functions to the pg_buffercache
Next
From: Mahendra Singh Thalor
Date:
Subject: Re: Non-text mode for pg_dumpall