diff options
| author | Teodor Sigaev <teodor@sigaev.ru> | 2018-05-10 13:31:47 +0300 |
|---|---|---|
| committer | Teodor Sigaev <teodor@sigaev.ru> | 2018-05-10 13:31:47 +0300 |
| commit | 8e12f4a250d250a89153da2eb9b91c31bb80c483 (patch) | |
| tree | c09c7e452cacd9dfc8ff2b8fd2fb436c577e1184 /src/backend/utils/misc/guc.c | |
| parent | ddc1f32ee5073503a396c7a4df32865205dd3970 (diff) | |
| download | postgresql-8e12f4a250d250a89153da2eb9b91c31bb80c483.tar.gz postgresql-8e12f4a250d250a89153da2eb9b91c31bb80c483.zip | |
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
Diffstat (limited to 'src/backend/utils/misc/guc.c')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index f496ad62815..7cd2d2d80ef 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -3238,7 +3238,7 @@ static struct config_real ConfigureNamesReal[] = }, { - {"vacuum_cleanup_index_scale_factor", PGC_SIGHUP, AUTOVACUUM, + {"vacuum_cleanup_index_scale_factor", PGC_USERSET, AUTOVACUUM, gettext_noop("Number of tuple inserts prior to index cleanup as a fraction of reltuples."), NULL }, |