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

Commitb555093

Browse files
committed
In relevant log messages, indicate whether vacuums are aggressive.
Kyotaro Horiguchi, reviewed Masahiko Sawada, David G. Johnston, ÁlvaroHerrera, and me. Grammar correction to the final posted patch by me.Discussion:http://postgr.es/m/20170329.124649.193656100.horiguchi.kyotaro@lab.ntt.co.jp
1 parent0af98a9 commitb555093

File tree

1 file changed

+16
-5
lines changed

1 file changed

+16
-5
lines changed

‎src/backend/commands/vacuumlazy.c

Lines changed: 16 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -355,6 +355,7 @@ lazy_vacuum_rel(Relation onerel, int options, VacuumParams *params,
355355
params->log_min_duration))
356356
{
357357
StringInfoDatabuf;
358+
char*msgfmt;
358359

359360
TimestampDifference(starttime,endtime,&secs,&usecs);
360361

@@ -373,7 +374,11 @@ lazy_vacuum_rel(Relation onerel, int options, VacuumParams *params,
373374
* emitting individual parts of the message when not applicable.
374375
*/
375376
initStringInfo(&buf);
376-
appendStringInfo(&buf,_("automatic vacuum of table \"%s.%s.%s\": index scans: %d\n"),
377+
if (aggressive)
378+
msgfmt=_("automatic aggressive vacuum of table \"%s.%s.%s\": index scans: %d\n");
379+
else
380+
msgfmt=_("automatic vacuum of table \"%s.%s.%s\": index scans: %d\n");
381+
appendStringInfo(&buf,msgfmt,
377382
get_database_name(MyDatabaseId),
378383
get_namespace_name(RelationGetNamespace(onerel)),
379384
RelationGetRelationName(onerel),
@@ -486,10 +491,16 @@ lazy_scan_heap(Relation onerel, int options, LVRelStats *vacrelstats,
486491
pg_rusage_init(&ru0);
487492

488493
relname=RelationGetRelationName(onerel);
489-
ereport(elevel,
490-
(errmsg("vacuuming \"%s.%s\"",
491-
get_namespace_name(RelationGetNamespace(onerel)),
492-
relname)));
494+
if (aggressive)
495+
ereport(elevel,
496+
(errmsg("aggressively vacuuming \"%s.%s\"",
497+
get_namespace_name(RelationGetNamespace(onerel)),
498+
relname)));
499+
else
500+
ereport(elevel,
501+
(errmsg("vacuuming \"%s.%s\"",
502+
get_namespace_name(RelationGetNamespace(onerel)),
503+
relname)));
493504

494505
empty_pages=vacuumed_pages=0;
495506
num_tuples=tups_vacuumed=nkeep=nunused=0;

0 commit comments

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