https://pg.center/docs/19/pgprewarm.html
PostgreSQL 19 Documentation · F.31. pg_prewarm — preload relation data into buffer caches
Sep 27, 2026 - The pg_prewarm module provides a convenient way to load relation data into either the operating system buffer cache or the PostgreSQL buffer cache.
postgresqldocumentationprewarmpreloadrelation
https://monpg.app/blog/postgresql-cold-cache-restart-prewarm
PostgreSQL Cold Cache: pg_prewarm and Restart Warm-Up
Jun 19, 2026 - After a restart or failover, PostgreSQL serves reads from disk until caches refill. Measure warm-up with blks_read and pg_buffercache, automate it with...
warm uppostgresqlcoldcacheprewarm