diff options
| author | David Rowley <drowley@postgresql.org> | 2021-08-09 16:45:35 +1200 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2021-08-09 16:45:35 +1200 |
| commit | deb6ffd4fdeb589de7a13ac1791380a7138cf59f (patch) | |
| tree | 0d546fe2889cdd87640878cf9586a09eeb6a6d10 /src/test/modules/test_regex/sql/test_regex.sql | |
| parent | 4a3d806f38f99fecf8f2a2bf7990a7ebea9b6c63 (diff) | |
| download | postgresql-deb6ffd4fdeb589de7a13ac1791380a7138cf59f.tar.gz postgresql-deb6ffd4fdeb589de7a13ac1791380a7138cf59f.zip | |
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
Diffstat (limited to 'src/test/modules/test_regex/sql/test_regex.sql')
0 files changed, 0 insertions, 0 deletions