Thread

Re: Add pg_buffercache_mark_dirty[_all] functions to the pg_buffercache

Nazir Bilal Yavuz <byavuz81@gmail.com> — 2025-11-27T08:00:03Z

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