From d67b0bf471ba4e88aa3ed50871924efc91d7a27e Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 29 Mar 2011 11:11:12 -0400 Subject: [PATCH] In pg_upgrade, add C comment about how autovacuum is disabled. --- contrib/pg_upgrade/server.c | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/contrib/pg_upgrade/server.c b/contrib/pg_upgrade/server.c index 84bd03ed8e..4d5f37301b 100644 --- a/contrib/pg_upgrade/server.c +++ b/contrib/pg_upgrade/server.c @@ -169,7 +169,11 @@ start_postmaster(ClusterInfo *cluster, bool quiet) * same file because we get the error: "The process cannot access the file * because it is being used by another process." so we have to send all * other output to 'nul'. - */ + * + * Using autovacuum=off disables cleanup vacuum and analyze, but + * freeze vacuums can still happen, so we set + * autovacuum_freeze_max_age high too. + */ snprintf(cmd, sizeof(cmd), SYSTEMQUOTE "\"%s/pg_ctl\" -l \"%s\" -D \"%s\" " "-o \"-p %d -c autovacuum=off " -- 2.40.0