8000 Doc: mention that VACUUM can't utilize over 1GB of RAM · postgres/postgres@301d9bb · GitHub
[go: up one dir, main page]
Skip to content

Commit 301d9bb

Browse files
david-rowleydavid-rowley
committed
Doc: mention that VACUUM can't utilize over 1GB of RAM
Document that setting maintenance_work_mem to values over 1GB has no effect on VACUUM. Reported-by: Martín Marqués Author: Laurenz Albe Discussion: https://postgr.es/m/CABeG9LsZ2ozUMcqtqWu_-GiFKB17ih3p8wBHXcpfnHqhCnsc7A%40mail.gmail.com Backpatch-through: 9.6, oldest supported release
1 parent 6cfa2f9 commit 301d9bb

File tree

1 file changed

+6
-0
lines changed

1 file changed

+6
-0
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1529,6 +1529,12 @@ include_dir 'conf.d'
15291529
too high. It may be useful to control for this by separately
15301530
setting <xref linkend="guc-autovacuum-work-mem">.
15311531
</para>
1532+
<para>
1533+
Additionally, <command>VACUUM</command> is only able to utilize up to
1534+
a maximum of <literal>1GB</literal> of memory, so
1535+
<varname>maintenance_work_mem</varname> values higher than this have
1536+
no effect on <command>VACUUM</command>.
1537+
</para>
15321538
</listitem>
15331539
</varlistentry>
15341540

0 commit comments

Comments
 (0)
0