From d779754c5a2708a4359a77fa0948a1c0630e4f60 Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Wed, 23 Jul 2008 20:21:04 +0000 Subject: [PATCH] Ratchet up patch to improve autovacuum wraparound messages. Simon Riggs --- src/backend/postmaster/autovacuum.c | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/src/backend/postmaster/autovacuum.c b/src/backend/postmaster/autovacuum.c index aa4d790398..69350b3006 100644 --- a/src/backend/postmaster/autovacuum.c +++ b/src/backend/postmaster/autovacuum.c @@ -2650,16 +2650,15 @@ autovacuum_do_vac_analyze(autovac_table *tab, static void autovac_report_activity(autovac_table *tab) { -#define MAX_AUTOVAC_ACTIV_LEN (NAMEDATALEN * 2 + 32) +#define MAX_AUTOVAC_ACTIV_LEN (NAMEDATALEN * 2 + 56) char activity[MAX_AUTOVAC_ACTIV_LEN]; int len; /* Report the command and possible options */ if (tab->at_dovacuum) snprintf(activity, MAX_AUTOVAC_ACTIV_LEN, - "autovacuum: VACUUM%s%s", - tab->at_doanalyze ? " ANALYZE" : "", - tab->at_wraparound ? " (to prevent wraparound)" : ""); + "autovacuum: VACUUM%s", + tab->at_doanalyze ? " ANALYZE" : ""); else snprintf(activity, MAX_AUTOVAC_ACTIV_LEN, "autovacuum: ANALYZE"); @@ -2670,7 +2669,8 @@ autovac_report_activity(autovac_table *tab) len = strlen(activity); snprintf(activity + len, MAX_AUTOVAC_ACTIV_LEN - len, - " %s.%s", tab->at_nspname, tab->at_relname); + " %s.%s%s", tab->at_nspname, tab->at_relname, + tab->at_wraparound ? " (to prevent wraparound)" : ""); /* Set statement_timestamp() to current time for pg_stat_activity */ SetCurrentStatementStartTimestamp(); -- 2.39.5