]> granicus.if.org Git - postgresql/commit
Various improvements of skipping index scan during vacuum technics
authorTeodor Sigaev <teodor@sigaev.ru>
Thu, 10 May 2018 10:31:47 +0000 (13:31 +0300)
committerTeodor Sigaev <teodor@sigaev.ru>
Thu, 10 May 2018 10:31:47 +0000 (13:31 +0300)
commit8e12f4a250d250a89153da2eb9b91c31bb80c483
treec09c7e452cacd9dfc8ff2b8fd2fb436c577e1184
parentddc1f32ee5073503a396c7a4df32865205dd3970
Various improvements of skipping index scan during vacuum technics

- 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
doc/src/sgml/config.sgml
src/backend/access/nbtree/nbtpage.c
src/backend/access/nbtree/nbtree.c
src/backend/utils/misc/guc.c
src/bin/psql/tab-complete.c