pgfincore

pig build pkg pgfincore;		# build rpm/deb

pig repo add pgdg -u    # add pgdg repo and update cache

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

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

CREATE EXTENSION pgfincore;

SELECT * FROM pgfincore('pgbench_accounts');

SELECT * FROM pgsysconf();          -- os_page_size, os_pages_free, os_total_pages
SELECT * FROM pgsysconf_pretty();   -- same with human-readable output

SELECT * FROM pgfadvise_willneed('pgbench_accounts');

SELECT * FROM pgfadvise_dontneed('pgbench_accounts');

SELECT * FROM pgfadvise_normal('relation');
SELECT * FROM pgfadvise_sequential('relation');
SELECT * FROM pgfadvise_random('relation');

-- Snapshot
CREATE TABLE pgfincore_snapshot AS
  SELECT 'pgbench_accounts'::text AS relname, *, now() AS date_snapshot
  FROM pgfincore('pgbench_accounts', true);

-- Restore
SELECT * FROM pgfadvise_loader('pgbench_accounts', 0, true, true,
               (SELECT databit FROM pgfincore_snapshot
                WHERE relname = 'pgbench_accounts' AND segment = 0));

-- Load first 3 pages, unload next 3
SELECT * FROM pgfadvise_loader('pgbench_accounts', 0, true, true, B'111000');
-- Load only
SELECT * FROM pgfadvise_loader('pgbench_accounts', 0, true, false, B'111000');
-- Unload only
SELECT * FROM pgfadvise_loader('pgbench_accounts', 0, false, true, B'111000');