Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit79ccd7c

Browse files
committed
pg_prewarm: Add automatic prewarm feature.
Periodically while the server is running, and at shutdown, write out alist of blocks in shared buffers. When the server reaches consistency-- unfortunatey, we can't do it before that point without breakingthings -- 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 parent66ed382 commit79ccd7c

File tree

11 files changed

+1035
-4
lines changed

11 files changed

+1035
-4
lines changed

‎contrib/file_fdw/data/list1.csv

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
1,foo
2+
1,bar

‎contrib/file_fdw/data/list2.bad

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
2,baz
2+
1,qux

‎contrib/file_fdw/data/list2.csv

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
2,baz
2+
2,qux

‎contrib/pg_prewarm/Makefile

Lines changed: 2 additions & 2 deletions
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.oautoprewarm.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
ifdefUSE_PGXS

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp