]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: Fix misleading statement about VACUUM memory limits
authorDavid Rowley <drowley@postgresql.org>
Mon, 9 Aug 2021 04:48:37 +0000 (16:48 +1200)
committerDavid Rowley <drowley@postgresql.org>
Mon, 9 Aug 2021 04:48:37 +0000 (16:48 +1200)
commit6df2971d32803c44d671d3a93fc718cb82fd7883
treee7b711d838ad60acd6338683440afe15efd1dd31
parentcfb70a120bbac4b197aabc663e1400c3cb599ffe
Doc: Fix misleading statement about VACUUM memory limits

In ec34040af I added a mention that there was no point in setting
maintenance_work_limit to anything higher than 1GB for vacuum, but that
was incorrect as ginInsertCleanup() also looks at what
maintenance_work_mem is set to during VACUUM and that's not limited to
1GB.

Here I attempt to make it more clear that the limitation is only around
the number of dead tuple identifiers that we can collect during VACUUM.

I've also added a note to autovacuum_work_mem to mention this limitation.
I didn't do that in ec34040af as I'd had some wrong-headed ideas about
just limiting the maximum value for that GUC to 1GB.

Author: David Rowley
Discussion: https://postgr.es/m/CAApHDvpGwOAvunp-E-bN_rbAs3hmxMoasm5pzkYDbf36h73s7w@mail.gmail.com
Backpatch-through: 9.6, same as ec34040af
doc/src/sgml/config.sgml