Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions

From: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>, Aidar Imamov <a(dot)imamov(at)postgrespro(dot)ru>, Joseph Koshakow <koshy44(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions
Date: 2025-04-10 13:50:36
Message-ID: Z/fMrPzOekEdaB7D@ip-10-97-1-34.eu-west-3.compute.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2025-04-10 13:54:12 Re: Correct documentation for protocol version
Previous Message Tomas Vondra 2025-04-10 13:35:24 Re: Add os_page_num to pg_buffercache