diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2013-02-02 18:50:42 +0000 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2013-02-02 18:50:42 +0000 |
| commit | 9dd99933708994bb307efcf214b11f6061bbe18f (patch) | |
| tree | 559e3b1918526a821aa280f2dd34c27fb8958df7 /src/backend/utils/misc/guc.c | |
| parent | 231dbb3c9be755eebdf677b469f2dd4494e7937f (diff) | |
| download | postgresql-9dd99933708994bb307efcf214b11f6061bbe18f.tar.gz postgresql-9dd99933708994bb307efcf214b11f6061bbe18f.zip | |
Mark vacuum_defer_cleanup_age as PGC_POSTMASTER.
Following bug analysis of #7819 by Tom Lane
Diffstat (limited to 'src/backend/utils/misc/guc.c')
| -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 c37c1d9a5fb..25722fac68d 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -1880,7 +1880,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 }, |