Prewarming PostgreSQL I/O caches

PostgreSQL uses shared_buffers to cache blocks in memory. The idea is to reduce disk I/O and to speed up the database in the most efficient way possible. During normal operations your database cache will be pretty useful and ensure good response times. However, what happens if your database instance is restarted - for whatever reason? Your PostgreSQL database performance will suffer until your I/O

[msykt]

“In most cases, people might want pg_prewarm to take care of caching automatically on startup. The way to achieve this is to add pg_prewarm to shared_preload_libraries and to restart the database server. ”

[tmatsuu]

予めバッファに乗せるprewarmingを実現するPostgreSQLの拡張pg_prewarm。標準のcontribに含まれてるらしい。知らなかった。