Add pg_buffercache_evict() function for testing. When testing buffer pool logic, it is useful to be able to evict arbitrary blocks. This function can be used in SQL queries over the pg_buffercache view to set up a wide range of buffer pool states. Of course, buffer mappings might change concurrently so you might evict a block other than the one you had in mind, and another session might bring it back in at any time. That's OK for the intended purpose of setting up developer testing scenarios, and more complicated interlocking schemes to give stronger guararantees about that would likely be less flexible for actual testing work anyway. Superuser-only.
Author: Palak Chaturvedi <[email protected]> Author: Thomas Munro <[email protected]> (docs, small tweaks) Reviewed-by: Nitin Jadhav <[email protected]> Reviewed-by: Andres Freund <[email protected]> Reviewed-by: Cary Huang <[email protected]> Reviewed-by: Cédric Villemain <[email protected]> Reviewed-by: Jim Nasby <[email protected]> Reviewed-by: Maxim Orlov <[email protected]> Reviewed-by: Thomas Munro <[email protected]> Reviewed-by: Melanie Plageman <[email protected]> Discussion: https://postgr.es/m/calfch19pw48zwwzuorspsav9hqt0upyabpc4boz4w+c7ff5...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/13453eedd3f692f8dcf8e334396eee84f00fdde2 Modified Files -------------- contrib/pg_buffercache/Makefile | 2 +- contrib/pg_buffercache/meson.build | 1 + .../pg_buffercache/pg_buffercache--1.4--1.5.sql | 6 +++ contrib/pg_buffercache/pg_buffercache.control | 2 +- contrib/pg_buffercache/pg_buffercache_pages.c | 20 +++++++ doc/src/sgml/pgbuffercache.sgml | 39 +++++++++++--- src/backend/storage/buffer/bufmgr.c | 63 ++++++++++++++++++++++ src/include/storage/bufmgr.h | 2 + 8 files changed, 127 insertions(+), 8 deletions(-)
