Commit9dd9993

committed

Mark vacuum_defer_cleanup_age as PGC_POSTMASTER.

Following bug analysis of #7819 by Tom Lane

1 parent231dbb3 commit9dd9993Copy full SHA for 9dd9993

File tree

-3

lines changed

-3

lines changed

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -2288,8 +2288,7 @@ SET ENABLE_SEQSCAN TO OFF;`
`2288`	`2288`	`is measured in terms of number of write transactions occurring on the`
`2289`	`2289`	`primary server, it is difficult to predict just how much additional`
`2290`	`2290`	`grace time will be made available to standby queries.`
`2291`		`- This parameter can only be set in the <filename>postgresql.conf</>`
`2292`		`- file or on the server command line.`
	`2291`	`+ This parameter can only be set at server start.`
`2293`	`2292`	`</para>`
`2294`	`2293`	`<para>`
`2295`	`2294`	`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
`@@ -1880,7 +1880,12 @@ static struct config_int ConfigureNamesInt[] =`
`1880`	`1880`	`},`
`1881`	`1881`
`1882`	`1882`	`{`
`1883`		`-{"vacuum_defer_cleanup_age",PGC_SIGHUP,REPLICATION_MASTER,`
	`1883`	`+/*`
	`1884`	`+ * Setting this to a higher value without restarting postmaster`
	`1885`	`+ * can cause various bugs in TOAST object removal, CLUSTER and`
	`1886`	`+ * possibly other places, so this must be changed only on restart.`
	`1887`	`+ */`
	`1888`	`+{"vacuum_defer_cleanup_age",PGC_POSTMASTER,REPLICATION_MASTER,`
`1884`	`1889`	`gettext_noop("Number of transactions by which VACUUM and HOT cleanup should be deferred, if any."),`
`1885`	`1890`	`NULL`
`1886`	`1891`	`},`

Comments

(0)