diff options
| author | Michael Paquier <michael@paquier.xyz> | 2021-03-03 10:14:21 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2021-03-03 10:14:21 +0900 |
| commit | 57e6db706e81fd2609fa385677e6ae72471822fe (patch) | |
| tree | e5abc539f462608385828e183ab3e2865707e9ba /doc/src | |
| parent | 5b2f2af3d9d57626b9052a05337e32ad1399093d (diff) | |
| download | postgresql-57e6db706e81fd2609fa385677e6ae72471822fe.tar.gz postgresql-57e6db706e81fd2609fa385677e6ae72471822fe.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/reindexdb.sgml | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index a3b0f7ce319..80a7f84886b 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -237,6 +237,16 @@ PostgreSQL documentation </listitem> </varlistentry> + <varlistentry> + <term><option>--tablespace=<replaceable class="parameter">tablespace</replaceable></option></term> + <listitem> + <para> + Specifies the tablespace where indexes are rebuilt. (This name is + processed as a double-quoted identifier.) + </para> + </listitem> + </varlistentry> + <varlistentry> <term><option>-v</option></term> <term><option>--verbose</option></term> |