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

Categories

Background worker, Contrib module, Performance