From 2113574be8467e044a74b7eb4da6841e78384e2e Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Mon, 4 Feb 2013 16:42:12 +0000 Subject: [PATCH] Reset vacuum_defer_cleanup_age to PGC_SIGHUP. Revert commit 84725aa5efe11688633b553e58113efce4181f2e --- doc/src/sgml/config.sgml | 3 ++- src/backend/utils/misc/guc.c | 7 +------ 2 files changed, 3 insertions(+), 7 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 1f4114dd4bb..1e42a2619bf 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -2059,7 +2059,8 @@ SET ENABLE_SEQSCAN TO OFF; is measured in terms of number of write transactions occurring on the primary server, it is difficult to predict just how much additional grace time will be made available to standby queries. - This parameter can only be set at server start. + This parameter can only be set in the postgresql.conf + file or on the server command line. You should also consider setting hot_standby_feedback diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index f9a5efe100c..a363441d8f7 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -1853,12 +1853,7 @@ static struct config_int ConfigureNamesInt[] = }, { - /* - * Setting this to a higher value without restarting postmaster - * can cause various bugs in TOAST object removal, CLUSTER and - * possibly other places, so this must be changed only on restart. - */ - {"vacuum_defer_cleanup_age", PGC_POSTMASTER, REPLICATION_MASTER, + {"vacuum_defer_cleanup_age", PGC_SIGHUP, REPLICATION_MASTER, gettext_noop("Number of transactions by which VACUUM and HOT cleanup should be deferred, if any."), NULL }, -- 2.39.5