diff options
author | Simon Riggs <simon@2ndQuadrant.com> | 2013-02-02 18:49:54 +0000 |
---|---|---|
committer | Simon Riggs <simon@2ndQuadrant.com> | 2013-02-02 18:49:54 +0000 |
commit | 84725aa5efe11688633b553e58113efce4181f2e (patch) | |
tree | a501c3ea950fcca764d574abd7727f0b1a8d302b /src | |
parent | e8ae01966115a35d3815e0445da5f78878f6dd14 (diff) | |
download | postgresql-84725aa5efe11688633b553e58113efce4181f2e.tar.gz postgresql-84725aa5efe11688633b553e58113efce4181f2e.zip |
Mark vacuum_defer_cleanup_age as PGC_POSTMASTER.
Following bug analysis of #7819 by Tom Lane
Diffstat (limited to 'src')
-rw-r--r-- | src/backend/utils/misc/guc.c | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 6128694200f..b0af9f5c9ae 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -1881,7 +1881,12 @@ static struct config_int ConfigureNamesInt[] = }, { - {"vacuum_defer_cleanup_age", PGC_SIGHUP, REPLICATION_MASTER, + /* + * 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, gettext_noop("Number of transactions by which VACUUM and HOT cleanup should be deferred, if any."), NULL }, |