Contents
pg_prewarm
A contrib module providing a function which, when executed, loads relation data into either the operating system buffer cache or the PostgreSQL buffer cache
pg_prewarm is a contrib module providing a function which, when executed, loads relation data into either the operating system buffer cache or the PostgreSQL buffer cache. From PostgreSQL 11 it also provides a background worker to automate this.
pg_prewarm was added in PostgreSQL 9.4.
Change history
- PostgreSQL 11 (version 1.2)
- automatic prewarm feature implemented as a background worker added (commit 79ccd7cb)
- PostgreSQL 9.6 (version 1.1)
- parallel query support added (commit 6b3586ca)
- PostgreSQL 9.4 (version 1.0)
- added (commit c32afe53)
References
- PostgreSQL documentation: pg_prewarm
Useful links
- Autoprewarm: A New Functionality in pg_prewarm - September 2018 blog article by EnterpriseDB