• Teodor Sigaev's avatar
    Various improvements of skipping index scan during vacuum technics · 8e12f4a2
    Teodor Sigaev authored
    - Change vacuum_cleanup_index_scale_factor GUC to PGC_USERSET.
      vacuum_cleanup_index_scale_factor GUC was defined as PGC_SIGHUP.  But this
      GUC affects not only autovacuum.  So it might be useful to change it from user
      session in order to influence manually runned VACUUM.
    - Add missing tab-complete support for vacuum_cleanup_index_scale_factor
      reloption.
    - Fix condition for B-tree index cleanup.
      Zero value of vacuum_cleanup_index_scale_factor means that user wants B-tree
      index cleanup to be never skipped.
    - Documentation and comment improvements
    
    Authors: Justin Pryzby, Alexander Korotkov, Liudmila Mantrova
    Reviewed by: all authors and Robert Haas
    Discussion: https://www.postgresql.org/message-id/flat/20180502023025.GD7631%40telsasoft.com
    8e12f4a2
config.sgml 384 KB