diff options
author | David Rowley <drowley@postgresql.org> | 2021-07-04 22:30:35 +1200 |
---|---|---|
committer | David Rowley <drowley@postgresql.org> | 2021-07-04 22:30:35 +1200 |
commit | 4a9960e0adfe6faa692a985ae70262f6b4ad1523 (patch) | |
tree | 955a3681d408080184f7827be7de587eece25774 /doc/src | |
parent | 437d74f498c82c8a620db4991f9066a89964aa9d (diff) | |
download | postgresql-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.sgml | 6 |
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> |