Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions - Mailing list pgsql-hackers

From Bertrand Drouvot
Subject Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions
Date
Msg-id Z/fMrPzOekEdaB7D@ip-10-97-1-34.eu-west-3.compute.internal
Whole thread Raw
In response to Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions  (Andres Freund <andres@anarazel.de>)
Responses Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions
List pgsql-hackers
Hi,

On Tue, Apr 08, 2025 at 02:40:52AM -0400, Andres Freund wrote:
> I think it's ok for now.  It might be worth doing a larger redesign of the
> pgbuffercache docs at some point...
> 
> 
> Pushed.
> 
> 
> Thanks for your patches and thanks for all the reviewers getting this ready!

Thanks for the patch! That sounds like a great addition. I was doing some
tests and did not see any issues. Also while doing the tests I thouhgt that it
could be useful to evict only from a subset of NUMA nodes (now that NUMA
awareness is in). We'd need to figure out what to do for buffers that are spread
across NUMA nodes though.

Does that sound like an idea worth to spend time on? (If so, I'd be happy to work
on it).

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Add os_page_num to pg_buffercache
Next
From: Fujii Masao
Date:
Subject: Re: Correct documentation for protocol version