Commitac148a2

committed

Mark vacuum_defer_cleanup_age as PGC_POSTMASTER.

Following bug analysis of #7819 by Tom Lane

1 parent3c6e719 commitac148a2Copy full SHA for ac148a2

File tree

-3

lines changed

-3

lines changed

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -2059,8 +2059,7 @@ SET ENABLE_SEQSCAN TO OFF;`
`2059`	`2059`	`is measured in terms of number of write transactions occurring on the`
`2060`	`2060`	`primary server, it is difficult to predict just how much additional`
`2061`	`2061`	`grace time will be made available to standby queries.`
`2062`		`- This parameter can only be set in the <filename>postgresql.conf</>`
`2063`		`- file or on the server command line.`
	`2062`	`+ This parameter can only be set at server start.`
`2064`	`2063`	`</para>`
`2065`	`2064`	`<para>`
`2066`	`2065`	`You should also consider setting <varname>hot_standby_feedback</>`

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1853,7 +1853,12 @@ static struct config_int ConfigureNamesInt[] =`
`1853`	`1853`	`},`
`1854`	`1854`
`1855`	`1855`	`{`
`1856`		`-{"vacuum_defer_cleanup_age",PGC_SIGHUP,REPLICATION_MASTER,`
	`1856`	`+/*`
	`1857`	`+ * Setting this to a higher value without restarting postmaster`
	`1858`	`+ * can cause various bugs in TOAST object removal, CLUSTER and`
	`1859`	`+ * possibly other places, so this must be changed only on restart.`
	`1860`	`+ */`
	`1861`	`+{"vacuum_defer_cleanup_age",PGC_POSTMASTER,REPLICATION_MASTER,`
`1857`	`1862`	`gettext_noop("Number of transactions by which VACUUM and HOT cleanup should be deferred, if any."),`
`1858`	`1863`	`NULL`
`1859`	`1864`	`},`

Comments

(0)