Обсуждение: pgsql: Add toast-level reloption for vacuum_index_cleanup

Поиск
Список
Период
Сортировка

pgsql: Add toast-level reloption for vacuum_index_cleanup

От
Michael Paquier
Дата:
Add toast-level reloption for vacuum_index_cleanup

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
Reviewed-by: Peter Geoghegan
Discussion: https://postgr.es/m/CAD21AoCqs8iN04RX=i1KtLSaX5RrTEM04b7NHYps4+rqtpWNEg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ce59b75d449d9152667ce3e9eab33ef2872bfd98

Modified Files
--------------
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(-)