Content-Length: 322135 | pFad | http://github.com/tonybelloni/postgres/commit/79ccd7cbd5ca44bee0191d12e9e65abf702899e7

A8 pg_prewarm: Add automatic prewarm feature. · tonybelloni/postgres@79ccd7c · GitHub
Skip to content

Commit 79ccd7c

Browse files
robertmhaasrobertmhaas
committed
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
1 parent 66ed382 commit 79ccd7c

File tree

11 files changed

+1035
-4
lines changed

11 files changed

+1035
-4
lines changed

‎contrib/file_fdw/data/list1.csv

+2
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
1,foo
2+
1,bar

‎contrib/file_fdw/data/list2.bad

+2
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
2,baz
2+
1,qux

‎contrib/file_fdw/data/list2.csv

+2
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
2,baz
2+
2,qux

‎contrib/pg_prewarm/Makefile

+2-2
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,10 @@
11
# contrib/pg_prewarm/Makefile
22

33
MODULE_big = pg_prewarm
4-
OBJS = pg_prewarm.o $(WIN32RES)
4+
OBJS = pg_prewarm.o autoprewarm.o $(WIN32RES)
55

66
EXTENSION = pg_prewarm
7-
DATA = pg_prewarm--1.1.sql pg_prewarm--1.0--1.1.sql
7+
DATA = pg_prewarm--1.1--1.2.sql pg_prewarm--1.1.sql pg_prewarm--1.0--1.1.sql
88
PGFILEDESC = "pg_prewarm - preload relation data into system buffer cache"
99

1010
ifdef USE_PGXS

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/tonybelloni/postgres/commit/79ccd7cbd5ca44bee0191d12e9e65abf702899e7

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy