]> granicus.if.org Git - postgresql/commit
pg_prewarm: Add automatic prewarm feature.
authorRobert Haas <rhaas@postgresql.org>
Mon, 21 Aug 2017 18:43:00 +0000 (14:43 -0400)
committerRobert Haas <rhaas@postgresql.org>
Mon, 21 Aug 2017 18:17:39 +0000 (14:17 -0400)
commit79ccd7cbd5ca44bee0191d12e9e65abf702899e7
tree61870b5ef1e67989c29ab070c11378e8522330c9
parent66ed3829df959adb47f71d7c903ac59f0670f3e1
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
contrib/file_fdw/data/list1.csv [new file with mode: 0644]
contrib/file_fdw/data/list2.bad [new file with mode: 0644]
contrib/file_fdw/data/list2.csv [new file with mode: 0644]
contrib/pg_prewarm/Makefile
contrib/pg_prewarm/autoprewarm.c [new file with mode: 0644]
contrib/pg_prewarm/pg_prewarm--1.1--1.2.sql [new file with mode: 0644]
contrib/pg_prewarm/pg_prewarm.control
doc/src/sgml/pgprewarm.sgml
src/backend/storage/buffer/freelist.c
src/include/storage/buf_internals.h
src/tools/pgindent/typedefs.list