Add toast-level reloption for vacuum_index_cleanup

Enterprise / PostgreSQL - Michael Paquier [paquier.xyz] - 25 June 2019 00:09 EDT

a96c41f has introduced the option for heap, but it still lacked the
variant to control the behavior for toast relations.

While on it, refactor the tests so as they stress more scenarios with the various values that vacuum_index_cleanup can use. It would be useful to couple those tests with pageinspect to check that pages are actually cleaned up, but this is left for later.

Author: Masahiko Sawada, Michael Paquier

ce59b75d44 Add toast-level reloption for vacuum_index_cleanup
doc/src/sgml/ref/create_table.sgml | 2 +-
src/backend/access/common/reloptions.c | 2 +-
src/bin/psql/tab-complete.c | 1 +
src/test/regress/expected/vacuum.out | 34 ++++++++++++++++++++++++++++++----
src/test/regress/sql/vacuum.sql | 34 ++++++++++++++++++++++++++++++----
5 files changed, 63 insertions(+), 10 deletions(-)

Upstream: git.postgresql.org


  • Share