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

Commit70adf2f

Browse files
committed
Make VACUUM VERBOSE report the number of skipped frozen pages.
Previously manual VACUUM did not report the number of skipped frozenpages even when VERBOSE option is specified. But this information ishelpful to monitor the VACUUM activity, and also autovacuum reports thatnumber in the log file when the condition of log_autovacuum_min_durationis met.This commit changes VACUUM VERBOSE so that it reports the numberof frozen pages that it skips.Author: Masahiko SawadaReviewed-by: Yugo Nagata and Jim NasbyDiscussion:http://postgr.es/m/CAD21AoDZQKCxo0L39Mrq08cONNkXQKXuh=2DP1Q8ebmt35SoaA@mail.gmail.com
1 parent7b504eb commit70adf2f

File tree

2 files changed

+7
-3
lines changed

2 files changed

+7
-3
lines changed

‎doc/src/sgml/ref/vacuum.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -273,7 +273,7 @@ DETAIL: CPU: user: 0.06 s, system: 0.01 s, elapsed: 0.07 s.
273273
INFO: "onek": found 3000 removable, 1000 nonremovable tuples in 143 pages
274274
DETAIL: 0 dead tuples cannot be removed yet.
275275
There were 0 unused item pointers.
276-
Skipped 0 pages due to buffer pins.
276+
Skipped 0 pages due to buffer pins, 0 frozen pages.
277277
0 pages are entirely empty.
278278
CPU: user: 0.39 s, system: 0.07 s, elapsed: 1.56 s.
279279
INFO: analyzing "public.onek"

‎src/backend/commands/vacuumlazy.c

Lines changed: 6 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1341,10 +1341,14 @@ lazy_scan_heap(Relation onerel, int options, LVRelStats *vacrelstats,
13411341
nkeep,OldestXmin);
13421342
appendStringInfo(&buf,_("There were %.0f unused item pointers.\n"),
13431343
nunused);
1344-
appendStringInfo(&buf,ngettext("Skipped %u page due to buffer pins.\n",
1345-
"Skipped %u pages due to buffer pins.\n",
1344+
appendStringInfo(&buf,ngettext("Skipped %u page due to buffer pins,",
1345+
"Skipped %u pages due to buffer pins,",
13461346
vacrelstats->pinskipped_pages),
13471347
vacrelstats->pinskipped_pages);
1348+
appendStringInfo(&buf,ngettext("%u frozen page.\n",
1349+
"%u frozen pages.\n",
1350+
vacrelstats->frozenskipped_pages),
1351+
vacrelstats->frozenskipped_pages);
13481352
appendStringInfo(&buf,ngettext("%u page is entirely empty.\n",
13491353
"%u pages are entirely empty.\n",
13501354
empty_pages),

0 commit comments

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