aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorDavid Rowley <drowley@postgresql.org>2021-07-04 22:28:38 +1200
committerDavid Rowley <drowley@postgresql.org>2021-07-04 22:28:38 +1200
commitec34040af104a1d25233eccd5715863ace6cbb10 (patch)
tree415c4a83d01aa40ec173fd90c3087418f637397e /doc/src
parent63b1af94375cc2be06a5d6a932db24cd8e9f45e9 (diff)
downloadpostgresql-ec34040af104a1d25233eccd5715863ace6cbb10.tar.gz
postgresql-ec34040af104a1d25233eccd5715863ace6cbb10.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 6098f6b0202..381d8636ab4 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -1893,6 +1893,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>