Post

To see which WAL records carry full-page images, PostgreSQL 18's pg_walinspect has pg_get_wal_block_info(start_lsn, end_lsn) gives one row per block reference; block_fpi_length > 0 means the page was imaged. After a checkpoint, the first change to every page was.