Commitc3c0d7b

committed

Raise max setting of checkpoint_timeout to 1d

Previously checkpoint_timeout was capped at 3600sNew max setting is 86400s = 24h = 1dDiscussion: 32558.1454471895@sss.pgh.pa.us

1 parent5280309 commitc3c0d7bCopy full SHA for c3c0d7b

File tree

-3

lines changed

-3

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2614,7 +2614,7 @@ include_dir 'conf.d'`
`2614`	`2614`	`<listitem>`
`2615`	`2615`	`<para>`
`2616`	`2616`	`Maximum time between automatic WAL checkpoints, in seconds.`
`2617`		`- The valid range is between 30 seconds and onehour.`
	`2617`	`+ The valid range is between 30 seconds and oneday.`
`2618`	`2618`	`The default is five minutes (<literal>5min</>).`
`2619`	`2619`	`Increasing this parameter can increase the amount of time needed`
`2620`	`2620`	`for crash recovery.`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2250,7 +2250,7 @@ static struct config_int ConfigureNamesInt[] =`
`2250`	`2250`	`GUC_UNIT_S`
`2251`	`2251`	`},`
`2252`	`2252`	`&CheckPointTimeout,`
`2253`		`-300,30,3600,`
	`2253`	`+300,30,86400,`
`2254`	`2254`	`NULL,NULL,NULL`
`2255`	`2255`	`},`
`2256`	`2256`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -203,7 +203,7 @@`
`203`	`203`
`204`	`204`	`# - Checkpoints -`
`205`	`205`
`206`		`-#checkpoint_timeout = 5min# range 30s-1h`
	`206`	`+#checkpoint_timeout = 5min# range 30s-1d`
`207`	`207`	`#max_wal_size = 1GB`
`208`	`208`	`#min_wal_size = 80MB`
`209`	`209`	`#checkpoint_completion_target = 0.5# checkpoint target duration, 0.0 - 1.0`

Comments

(0)