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