pg_dropcache

pg_dropcache is a PostgreSQL extension that invalidates shared_buffers cache.

PostgreSQL supported versions are 11, 12, 13, 14, 15 and 16.

PostgreSQL 17 and 18 are not supported because pg_buffercache extension provides following new functions: - pg_buffercache_evict() - pg_buffercache_evict_relation() - pg_buffercache_evict_all()

Installation

To install pg_dropcache clone this repository and run:

make install USE_PGXS=1

Then in psql (or any other client) execute:

create extension pg_dropcache;

Usage

WARNING: Dirty pages will be just dropped, therefore they won’t be flushed on the disk! It should be used with extreme caution!

To clear whole buffer cache for the current database run:

select pg_drop_cache();

To clear cache buffers for just a single relation:

select pg_drop_rel_cache(<relation oid>);

Use it at your own risk.