diff options
| author | Magnus Hagander <magnus@hagander.net> | 2008-12-08 15:11:39 +0000 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2008-12-08 15:11:39 +0000 |
| commit | bd33aca36ee441b72936d0bdb16508492233768d (patch) | |
| tree | b1483542630cdba186670c1db8d53a0d2135b1fc | |
| parent | 173a6760278f4c25aaa41c3ed70bae6fecb732aa (diff) | |
| download | postgresql-bd33aca36ee441b72936d0bdb16508492233768d.tar.gz postgresql-bd33aca36ee441b72936d0bdb16508492233768d.zip | |
Add note that autovacuum can use up several times maintenance_work_mem,
with warning against setting it too high.
| -rw-r--r-- | doc/src/sgml/config.sgml | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index f49ee28259c..cf99ba2c85f 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.198 2008/11/21 20:21:59 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.199 2008/12/08 15:11:39 mha Exp $ --> <chapter Id="runtime-config"> <title>Server Configuration</title> @@ -881,6 +881,11 @@ SET ENABLE_SEQSCAN TO OFF; than <varname>work_mem</varname>. Larger settings might improve performance for vacuuming and for restoring database dumps. </para> + <para> + Note that when autovacuum runs, up to + <xref linkend="guc-autovacuum-max-workers"> times this memory may be + allocated, so be careful not to set the default value too high. + </para> </listitem> </varlistentry> |