• David Rowley's avatar
    Doc: Fix misleading statement about VACUUM memory limits · b5815dd0
    David Rowley authored
    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
    b5815dd0
config.sgml 478 KB