On Mon, 2021-05-03 at 13:48 -0300, Martín Marqués wrote:
> We should add a line that indicates that there is a limitation (that
> should be IMO, backported to documentation of earlier versions as it
> affects all supported versions), at least until such limitation is
> lifted.
Here is a patch for that,
Yours,
Laurenz Albe
From 69ba1f6bef0209fa1093c39ba2e731641d7f5188 Mon Sep 17 00:00:00 2001
From: Laurenz Albe <laurenz.a...@cybertec.at>
Date: Wed, 5 May 2021 12:02:11 +0200
Subject: [PATCH] Document the 1GB memory limit for VACUUM
---
doc/src/sgml/config.sgml | 5 +++++
1 file changed, 5 insertions(+)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 3a062a145c..9219b5c90a 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -1901,6 +1901,11 @@ include_dir 'conf.d'
be used instead. The setting has no effect on the behavior of
<command>VACUUM</command> when run in other contexts.
</para>
+ <para>
+ Node that <command>VACUUM</command> has a hard-coded limit of 1GB
+ for the amount of memory used, so setting
+ <varname>autovacuum_work_mem</varname> higher than that has no effect.
+ </para>
</listitem>
</varlistentry>
--
2.26.3
