postgres.git / summary / log / commit / refs

commit    b5f6c4dbe023e769aef4669bc25bfb6310754602
Author:   Simon Riggs <simon@2ndQuadrant.com>
Date:     Mon Feb 04 16:41:37 2013 +0000
First released in: 9.3.0, 9.0.12, 9.1.8, 9.2.3

    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 79e438ca01c..a3113081008 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -2288,7 +2288,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 <filename>postgresql.conf</>
+        file or on the server command line.
        </para>
        <para>
         You should also consider setting <varname>hot_standby_feedback</>
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c
index 25722fac68d..c37c1d9a5fb 100644
--- a/src/backend/utils/misc/guc.c
+++ b/src/backend/utils/misc/guc.c
@@ -1880,12 +1880,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
 		},


[parent: 0e1bee9ff494]