vacuum_cleanup_index_scale_factor
A server parameter for minimizing unnecessary vacuum index scans
This entry relates to a PostgreSQL feature which is deprecated and may be desupported in future releases.
vacuum_cleanup_index_scale_factor is a deprecated configuration parameter making it possible to avoid unnecessary index scans during vacuum operations.
vacuum_cleanup_index_scale_factor was added in PostgreSQL 11 but deactivated in PostgreSQL 13 and removed entirely in PostgreSQL 14.
Default value
The default value for vacuum_cleanup_index_scale_factor is: 0.1.
Change history
- PostgreSQL 14
- removed (commit 9f3665fb)
- PostgreSQL 13
- disabled (in PostgreSQL 13.3; commit 9663d124)
- PostgreSQL 11
- added (commit 857f9c36)
References
- PostgreSQL 12 documentation: vacuum_cleanup_index_scale_factor
Useful links
- Reduce index scan during VACUUM (11) - 2018 blog article by Adrien Nayrat