Horton

Various improvements of skipping index scan during vacuum technics

Teodor Sigaev <teodor@sigaev.ru>

View on postgr.es
Commit: 8e12f4a250d250a89153da2eb9b91c31bb80c483
Author: Teodor Sigaev <teodor@sigaev.ru>
Date: 2018-05-10T10:31:47Z
Releases: 11.0 
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

Files

PathChange+/−
doc/src/sgml/config.sgml modified +27 −8
src/backend/access/nbtree/nbtpage.c modified +1 −1
src/backend/access/nbtree/nbtree.c modified +10 −9
src/backend/utils/misc/guc.c modified +1 −1
src/bin/psql/tab-complete.c modified +4 −2

Documentation touched

Discussion