Browse categories
Random entry
Blog
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (latest)
- PostgreSQL 14
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)
Predefined roles

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Useful links
Categories

pg_prewarm

A contrib module for loading relation data into 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

Categories