pgcozy

pig build pkg pgcozy;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pgcozy;		# install via package name, for the active PG version

pig install pgcozy -v 18;   # install for PG 18
pig install pgcozy -v 17;   # install for PG 17
pig install pgcozy -v 16;   # install for PG 16
pig install pgcozy -v 15;   # install for PG 15
pig install pgcozy -v 14;   # install for PG 14

CREATE EXTENSION pgcozy CASCADE; -- requires pg_buffercache, pg_prewarm

SELECT pgcozy_init();

-- Snapshot buffer pages with usagecount >= 3 (popularity 1-5)
SELECT pgcozy_snapshot(3);

-- Snapshot all buffered pages (popularity = 0)
SELECT pgcozy_snapshot(0);

-- Warm from a specific snapshot by ID
SELECT pgcozy_warm(1);

-- Warm from the latest snapshot
SELECT pgcozy_warm(0);

SELECT id, snapshot_date FROM pgcozy.snapshots;