mirror of
https://github.com/hanzoai/postgres.git
synced 2026-10-30 18:33:07 +00:00
Thomas Munro
46588db0af
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+c7FF566A@mail.gmail.com
7 lines
230 B
SQL
7 lines
230 B
SQL
\echo Use "ALTER EXTENSION pg_buffercache UPDATE TO '1.5'" to load this file. \quit
|
|
|
|
CREATE FUNCTION pg_buffercache_evict(IN int)
|
|
RETURNS bool
|
|
AS 'MODULE_PATHNAME', 'pg_buffercache_evict'
|
|
LANGUAGE C PARALLEL SAFE VOLATILE STRICT;
|