Horton

fix_autovacuum_log.patch

application/octet-stream

Download
Filename: fix_autovacuum_log.patch
Type: application/octet-stream
Part: 0
Message: Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru

Patch

Format: unified
File+−
src/backend/commands/vacuumlazy.c 3 4 
diff --git a/src/backend/commands/vacuumlazy.c b/src/backend/commands/vacuumlazy.c
index 8996d36..9ab5bde 100644
--- a/src/backend/commands/vacuumlazy.c
+++ b/src/backend/commands/vacuumlazy.c
@@ -376,10 +376,9 @@ lazy_vacuum_rel(Relation onerel, int options, VacuumParams *params,
 			initStringInfo(&buf);
 			if (params->is_wraparound)
 			{
-				if (aggressive)
-					msgfmt = _("automatic aggressive vacuum to prevent wraparound of table \"%s.%s.%s\": index scans: %d\n");
-				else
-					msgfmt = _("automatic vacuum to prevent wraparound of table \"%s.%s.%s\": index scans: %d\n");
+				/* autovacuum cannot be anti-wraparound and not aggressive vacuum */
+				Assert(aggressive);
+				msgfmt = _("automatic aggressive vacuum to prevent wraparound of table \"%s.%s.%s\": index scans: %d\n");
 			}
 			else
 			{