pgsql: Add --tablespace option to reindexdb

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add --tablespace option to reindexdb
Date: 2021-03-03 01:17:15
Message-ID: E1lHG8Z-0001TT-Ah@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add --tablespace option to reindexdb

This option provides REINDEX (TABLESPACE) for reindexdb, applying the
tablespace value given by the caller to all the REINDEX queries
generated.

While on it, this commit adds some tests for REINDEX TABLESPACE, with
and without CONCURRENTLY, when run on toast indexes and tables. Such
operations are not allowed, and toast relation names are not stable
enough to be part of the main regression test suite (even if using a PL
function with a TRY/CATCH logic, as CONCURRENTLY could not be tested).

Author: Michael Paquier
Reviewed-by: Mark Dilger, Daniel Gustafsson
Discussion: https://postgr.es/m/YDiaDMnzLICqeukl@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/57e6db706e81fd2609fa385677e6ae72471822fe

Modified Files
--------------
doc/src/sgml/ref/reindexdb.sgml | 10 ++++
src/bin/scripts/reindexdb.c | 109 +++++++++++++++++++++++++------------
src/bin/scripts/t/090_reindexdb.pl | 81 ++++++++++++++++++++++++++-
3 files changed, 163 insertions(+), 37 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2021-03-03 01:17:57 pgsql: Extend the abilities of libpq's target_session_attrs parameter.
Previous Message Peter Geoghegan 2021-03-02 22:07:08 pgsql: nbtree page deletion: Add leaftopparent assertion.