8000 Add note that autovacuum can use up several times maintenance_work_mem, · postgrespro/postgres_cluster@bd33aca · GitHub
[go: up one dir, main page]
Skip to content

Commit bd33aca

Browse files
mhagandermhagander
committed
Add note that autovacuum can use up several times maintenance_work_mem,
with warning against setting it too high.
1 parent 173a676 commit bd33aca

File tree

1 file changed

+6
-1
lines changed

1 file changed

+6
-1
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff 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 $ -->
22

33
<chapter Id="runtime-config">
44
<title>Server Configuration</title>
@@ -881,6 +881,11 @@ SET ENABLE_SEQSCAN TO OFF;
881881
than <varname>work_mem</varname>. Larger settings might improve
882882
performance for vacuuming and for restoring database dumps.
883883
</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>
884889
</listitem>
885890
</varlistentry>
886891

0 commit comments

Comments
 (0)
0