Post

ImportStatic
@importstatic.com

Postgres 18's WAL prefetcher skips a page whose record carries a full-page image, then prefetches that same page one record later anyway. Is anyone running standbys with recovery_prefetch off? https://importstatic.com/databases/postgres-recovery-prefetch-full-page-writes

importstatic.comPostgreSQL's recovery_prefetch prefetches pages the WAL already holdsrecovery_prefetch skips a page with a full-page image in the WAL, then prefetches it one record later. Spot it in pg_stat_recovery_prefetch on PostgreSQL 18.

0 reposts0 likes

No replies yet.