pgsql: Add toast-level reloption for vacuum_index_cleanup

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

pgsql: Add toast-level reloption for vacuum_index_cleanup

Michael Paquier-2
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@...

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