From ac148a2e9375708170d9c582da4c719832a89f6f Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Sat, 2 Feb 2013 18:51:21 +0000 Subject: Mark vacuum_defer_cleanup_age as PGC_POSTMASTER. Following bug analysis of #7819 by Tom Lane --- src/backend/utils/misc/guc.c | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'src') diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index a363441d8f7..f9a5efe100c 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -1853,7 +1853,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 }, -- cgit v1.2.3