Using pg-prewarm to cache database tables
Published: (Updated: ) by . Leave a Comment on Using pg-prewarm to cache database tables.
pg_prewarm pg_prewarm is a postgres extension that reads an entire table – hopefully caching it for you, ready for a benchmark run. When I used this on a large-ish pgbench SF-1000 DB I still saw some disk reads, maybe they were reads of an index? I am not sure. Anyhow the install/usage is simple. The […]