Horton

pg_prewarm: Add automatic prewarm feature.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 79ccd7cbd5ca44bee0191d12e9e65abf702899e7
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-08-21T18:17:39Z
Releases: 11.0 
pg_prewarm: Add automatic prewarm feature.

Periodically while the server is running, and at shutdown, write out a
list of blocks in shared buffers.  When the server reaches consistency
-- unfortunatey, we can't do it before that point without breaking
things -- reload those blocks into any still-unused shared buffers.

Mithun Cy and Robert Haas, reviewed and tested by Beena Emerson,
Amit Kapila, Jim Nasby, and Rafia Sabih.

Discussion: http://postgr.es/m/CAD__OugubOs1Vy7kgF6xTjmEqTR4CrGAv8w+ZbaY_+MZeitukw@mail.gmail.com

Files

PathChange+/−
contrib/file_fdw/data/list1.csv added +2 −0
contrib/file_fdw/data/list2.bad added +2 −0
contrib/file_fdw/data/list2.csv added +2 −0
contrib/pg_prewarm/autoprewarm.c added +924 −0
contrib/pg_prewarm/Makefile modified +2 −2
contrib/pg_prewarm/pg_prewarm--1.1--1.2.sql added +14 −0
contrib/pg_prewarm/pg_prewarm.control modified +1 −1
doc/src/sgml/pgprewarm.sgml modified +68 −1
src/backend/storage/buffer/freelist.c modified +17 −0
src/include/storage/buf_internals.h modified +1 −0
src/tools/pgindent/typedefs.list modified +2 −0

Documentation touched

Discussion