projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 66ed382) | patch
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
tree61870b5ef1e67989c29ab070c11378e8522330c9tree
parent66ed3829df959adb47f71d7c903ac59f0670f3e1commit | diff
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] blob
contrib/file_fdw/data/list2.bad [new file with mode: 0644] blob
contrib/file_fdw/data/list2.csv [new file with mode: 0644] blob
contrib/pg_prewarm/Makefile diff | blob | blame | history
contrib/pg_prewarm/autoprewarm.c [new file with mode: 0644] blob
contrib/pg_prewarm/pg_prewarm--1.1--1.2.sql [new file with mode: 0644] blob
contrib/pg_prewarm/pg_prewarm.control diff | blob | blame | history
doc/src/sgml/pgprewarm.sgml diff | blob | blame | history
src/backend/storage/buffer/freelist.c diff | blob | blame | history
src/include/storage/buf_internals.h diff | blob | blame | history
src/tools/pgindent/typedefs.list diff | blob | blame | history
Robert Haas's development tree.