• Peter Geoghegan's avatar
    Support disabling index bypassing by VACUUM. · 3499df0d
    Peter Geoghegan authored
    Generalize the INDEX_CLEANUP VACUUM parameter (and the corresponding
    reloption): make it into a ternary style boolean parameter.  It now
    exposes a third option, "auto".  The "auto" option (which is now the
    default) enables the "bypass index vacuuming" optimization added by
    commit 1e55e7d1.
    
    "VACUUM (INDEX_CLEANUP TRUE)" is redefined to once again make VACUUM
    simply do any required index vacuuming, regardless of how few dead
    tuples are encountered during the first scan of the target heap relation
    (unless there are exactly zero).  This gives users a way of opting out
    of the "bypass index vacuuming" optimization, if for whatever reason
    that proves necessary.  It is also expected to be used by PostgreSQL
    developers as a testing option from time to time.
    
    "VACUUM (INDEX_CLEANUP FALSE)" does the same thing as it always has: it
    forcibly disables both index vacuuming and index cleanup.  It's not
    expected to be used much in PostgreSQL 14.  The failsafe mechanism added
    by commit 1e55e7d1 addresses the same problem in a simpler way.
    INDEX_CLEANUP can now be thought of as a testing and compatibility
    option.
    
    Author: Peter Geoghegan <pg@bowt.ie>
    Reviewed-By: default avatarMasahiko Sawada <sawada.mshk@gmail.com>
    Reviewed-By: default avatarJustin Pryzby <pryzby@telsasoft.com>
    Discussion: https://postgr.es/m/CAH2-WznrBoCST4_Gxh_G9hA8NzGUbeBGnOUC8FcXcrhqsv6OHQ@mail.gmail.com
    3499df0d
vacuumdb.sgml 19.9 KB