aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorDavid Rowley <drowley@postgresql.org>2021-07-04 22:30:35 +1200
committerDavid Rowley <drowley@postgresql.org>2021-07-04 22:30:35 +1200
commit4a9960e0adfe6faa692a985ae70262f6b4ad1523 (patch)
tree955a3681d408080184f7827be7de587eece25774 /doc/src
parent437d74f498c82c8a620db4991f9066a89964aa9d (diff)
downloadpostgresql-4a9960e0adfe6faa692a985ae70262f6b4ad1523.tar.gz
postgresql-4a9960e0adfe6faa692a985ae70262f6b4ad1523.zip
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
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/config.sgml6
1 files changed, 6 insertions, 0 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 224e4d05ee9..a30761289ac 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -1732,6 +1732,12 @@ include_dir 'conf.d'
too high. It may be useful to control for this by separately
setting <xref linkend="guc-autovacuum-work-mem"/>.
</para>
+ <para>
+ Additionally, <command>VACUUM</command> is only able to utilize up to
+ a maximum of <literal>1GB</literal> of memory, so
+ <varname>maintenance_work_mem</varname> values higher than this have
+ no effect on <command>VACUUM</command>.
+ </para>
</listitem>
</varlistentry>