Commitbd33aca

committed

Add note that autovacuum can use up several times maintenance_work_mem,

with warning against setting it too high.

1 parent173a676 commitbd33acaCopy full SHA for bd33aca

File tree

-1

lines changed

-1

lines changed

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.198 2008/11/21 20:21:59 tgl Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.199 2008/12/08 15:11:39 mha Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter Id="runtime-config">`
`4`	`4`	`<title>Server Configuration</title>`
`@@ -881,6 +881,11 @@ SET ENABLE_SEQSCAN TO OFF;`
`881`	`881`	`than <varname>work_mem</varname>. Larger settings might improve`
`882`	`882`	`performance for vacuuming and for restoring database dumps.`
`883`	`883`	`</para>`
	`884`	`+ <para>`
	`885`	`+ Note that when autovacuum runs, up to`
	`886`	`+ <xref linkend="guc-autovacuum-max-workers"> times this memory may be`
	`887`	`+ allocated, so be careful not to set the default value too high.`
	`888`	`+ </para>`
`884`	`889`	`</listitem>`
`885`	`890`	`</varlistentry>`
`886`	`891`

Comments

(0)