pgfincore

pig build pkg pgfincore         # 构建 RPM / DEB 包

pig repo add pgdg -u          # 添加 PGDG 仓库并更新缓存

CREATE EXTENSION pgfincore;

SELECT * FROM pgfincore('pgbench_accounts');

SELECT * FROM pgsysconf();          -- os_page_size, os_pages_free, os_total_pages
SELECT * FROM pgsysconf_pretty();   -- 相同内容，人类可读格式输出

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');

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

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

-- 加载前 3 页，卸载后 3 页
SELECT * FROM pgfadvise_loader('pgbench_accounts', 0, true, true, B'111000');
-- 仅加载
SELECT * FROM pgfadvise_loader('pgbench_accounts', 0, true, false, B'111000');
-- 仅卸载
SELECT * FROM pgfadvise_loader('pgbench_accounts', 0, false, true, B'111000');