Commitcbccac3

committed

Reduce the default value of autovacuum_vacuum_cost_delay to 2ms.

This is a better way to implement the desired change of increasingautovacuum's default resource consumption.Discussion:https://postgr.es/m/28720.1552101086@sss.pgh.pa.us

1 parent52985e4 commitcbccac3Copy full SHA for cbccac3

File tree

-3

lines changed

-3

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7033,7 +7033,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;`
`7033`	`7033`	`Specifies the cost delay value that will be used in automatic`
`7034`	`7034`	`<command>VACUUM</command> operations. If -1 is specified, the regular`
`7035`	`7035`	`<xref linkend="guc-vacuum-cost-delay"/> value will be used.`
`7036`		`- The default value is20 milliseconds.`
	`7036`	`+ The default value is2 milliseconds.`
`7037`	`7037`	`This parameter can only be set in the <filename>postgresql.conf</filename>`
`7038`	`7038`	`file or on the server command line;`
`7039`	`7039`	`but the setting can be overridden for individual tables by`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3312,7 +3312,7 @@ static struct config_real ConfigureNamesReal[] =`
`3312`	`3312`	`GUC_UNIT_MS`
`3313`	`3313`	`},`
`3314`	`3314`	`&autovacuum_vac_cost_delay,`
`3315`		`-20,-1,100,`
	`3315`	`+2,-1,100,`
`3316`	`3316`	`NULL,NULL,NULL`
`3317`	`3317`	`},`
`3318`	`3318`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -589,7 +589,7 @@`
`589`	`589`	`#autovacuum_multixact_freeze_max_age = 400000000# maximum multixact age`
`590`	`590`	`# before forced vacuum`
`591`	`591`	`# (change requires restart)`
`592`		`-#autovacuum_vacuum_cost_delay =20ms# default vacuum cost delay for`
	`592`	`+#autovacuum_vacuum_cost_delay =2ms# default vacuum cost delay for`
`593`	`593`	`# autovacuum, in milliseconds;`
`594`	`594`	`# -1 means use vacuum_cost_delay`
`595`	`595`	`#autovacuum_vacuum_cost_limit = -1# default vacuum cost limit for`

Comments

(0)