pgsql: Add toast-level reloption for vacuum_index_cleanup

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add toast-level reloption for vacuum_index_cleanup
Date: 2019-06-25 00:19:18
Message-ID: E1hfZB8-0000AU-QR@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2019-06-25 02:19:06 pgsql: Fix thinkos in LookupFuncName() for function name lookups
Previous Message Thomas Munro 2019-06-24 21:44:21 pgsql: Don't unset MAKEFLAGS in non-GNU Makefile.