Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLESPACE

Edit
ID 2269
Title Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLESPACE
Topic SQL Commands
Created 2019-08-30 17:51:25
Last modified 2021-02-04 06:39:24 (3 years, 8 months ago)
Latest email 2021-02-15 02:58:02 (3 years, 7 months ago)
Status
2021-03: Committed
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
2020-03: Moved to next CF
2020-01: Moved to next CF
2019-11: Moved to next CF
2019-09: Moved to next CF
Target version
Authors Justin Pryzby (justinpryzby), Alexey Kondratov (ololobus)
Reviewers Justin Pryzby (justinpryzby), Cleysson Lima (cleyssonlima)Become reviewer
Committer Michael Paquier (michael-kun)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2269
git checkout commitfest/cf/2269
Emails
Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly
First at 2018-12-24 11:08:43 by Alexey Kondratov <a.kondratov at postgrespro.ru>
Latest at 2021-02-15 02:58:02 by Michael Paquier <michael at paquier.xyz>
Latest attachment (0001-Dead-code-REINDEX-CONCURRENTLY-TABLESPACE-.-c5b28604.patch) at 2021-02-15 02:10:50 from Justin Pryzby <pryzby at telsasoft.com>
    Attachment (0001-Dead-code-REINDEX-CONCURRENTLY-TABLESPACE-.-c5b28604.patch) at 2021-02-15 02:10:50 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v11-0001-Allow-REINDEX-to-change-tablespace.patch) at 2021-02-03 06:37:39 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v10-0002-Change-tablespace-of-partitioned-indexes-during-.patch) at 2021-02-01 15:28:57 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v9-0001-Allow-REINDEX-to-change-tablespace.patch) at 2021-01-29 17:56:47 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v8-0001-Allow-REINDEX-to-change-tablespace.patch) at 2021-01-27 21:19:06 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v7-0001-Refactor-code-to-detect-and-process-tablespace-mo.patch) at 2021-01-26 22:00:50 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v6-0001-Refactor-code-to-detect-and-process-tablespace-mo.patch) at 2021-01-26 06:58:32 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v5-0001-Extract-common-part-from-ATExecSetTableSpaceNoSto.patch) at 2021-01-25 20:11:38 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v4-0002-Allow-REINDEX-to-change-tablespace.patch) at 2021-01-22 14:07:02 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v3-0002-Allow-REINDEX-to-change-tablespace.patch) at 2021-01-21 20:48:08 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0002-Allow-REINDEX-to-change-tablespace.patch) at 2021-01-20 18:10:14 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Allow-REINDEX-to-change-tablespace.patch) at 2021-01-18 08:37:57 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (refactor-utility-opts-michael-6.patch) at 2021-01-13 13:39:40 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (refactor-utility-opts-michael-5.patch) at 2021-01-13 11:34:40 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (refactor-utility-opts-michael-4.patch) at 2020-12-23 07:38:18 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-refactor-utility-opts-michael-2.patch-hacked-on-by-J.patch) at 2020-12-22 21:15:37 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (refactor-utility-opts-michael-2.patch) at 2020-12-22 09:57:41 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (refactor-utility-opts-michael.patch) at 2020-12-22 06:47:57 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Convert-options-to-struct-Reindex-Cluster-Vacuum.patch) at 2020-12-15 23:58:37 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (0001-Convert-reindex-options-to-struct.patch) at 2020-12-15 00:14:18 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v34-0001-Convert-reindex-options-to-struct.patch) at 2020-12-12 19:45:26 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (0001-Convert-reindex-options-to-struct.patch) at 2020-12-12 08:20:35 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (utility-opts-v1.patch) at 2020-12-05 01:30:50 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v33-0001-ExecReindex-and-ReindexParams.patch) at 2020-12-04 19:54:15 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (refactor-ExecReindex.txt) at 2020-12-04 18:40:31 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v32-0001-ExecReindex-and-ReindexParams.patch) at 2020-12-04 01:25:43 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v31-0003-Refactor-and-reuse-set_rel_tablespace.patch) at 2020-12-03 04:30:08 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v32-reindex-cluster-gram.patch) at 2020-12-01 02:46:55 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v31-0005-Implement-vacuum-full-cluster-INDEX_TABLESPACE-t.patch) at 2020-11-30 14:12:42 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v30-0001-Refactor-gram.y-in-order-to-add-a-common-parenth.patch) at 2020-11-24 15:31:23 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v29-0001-Refactor-gram.y-in-order-to-add-a-common-parenth.patch) at 2020-10-31 18:36:11 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v28-0006-Implement-vacuum-full-cluster-INDEX_TABLESPACE-t.patch) at 2020-09-23 16:43:01 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v27-0001-Change-REINDEX-CLUSTER-to-accept-an-option-list.patch) at 2020-09-08 23:39:51 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v26-0001-Change-REINDEX-CLUSTER-to-accept-an-option-list.patch) at 2020-09-04 02:43:51 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v25-0001-Change-REINDEX-CLUSTER-to-accept-an-option-list.patch) at 2020-09-02 23:07:07 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v24-0007-Refactor-gram.y-in-order-to-add-a-common-parenth.patch) at 2020-09-02 21:00:17 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v23-0001-Change-REINDEX-CLUSTER-to-accept-an-option-list.patch) at 2020-09-02 04:56:44 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v22-0001-Change-REINDEX-CLUSTER-to-accept-an-option-list.patch) at 2020-08-11 07:09:22 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (psql-tab-reindex.patch) at 2020-08-09 11:02:52 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v21-0001-tab-completion-for-reindex-verbose.patch) at 2020-04-26 17:56:14 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v20-0001-tab-completion-for-reindex-verbose.patch) at 2020-04-12 01:33:52 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v19-0001-tab-completion-for-reindex-verbose.patch) at 2020-04-07 20:44:06 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v18-0007-Reuse-vac_analyze_option_list-for-cluster-and-re.patch) at 2020-04-07 12:40:18 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v18-0001-tab-completion-for-reindex-verbose.patch) at 2020-04-06 18:44:06 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v17-0001-tab-completion-for-reindex-verbose.patch) at 2020-04-03 18:27:12 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v16-0001-Change-REINDEX-CLUSTER-to-accept-an-option-list.patch) at 2020-04-01 13:08:36 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v15-0001-Allow-REINDEX-to-change-tablespace.patch) at 2020-04-01 11:57:18 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v14-0001-Allow-REINDEX-to-change-tablespace.patch) at 2020-03-28 00:11:12 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v13-0001-Allow-REINDEX-to-change-tablespace.patch) at 2020-03-27 20:15:42 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v12-0003-Allow-CLUSTER-and-VACUUM-FULL-to-change-tablespa.patch) at 2020-03-26 17:09:15 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v11-0001-Allow-REINDEX-to-change-tablespace.patch) at 2020-03-25 23:40:28 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v10-0001-Allow-REINDEX-to-change-tablespace.patch) at 2020-03-09 20:04:47 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v9-0001-Allow-CLUSTER-VACUUM-FULL-and-REINDEX-to-change-t.patch) at 2020-02-29 14:53:04 from Justin Pryzby <pryzby at telsasoft.com> (Patch: No)
    Attachment (v8-0001-Allow-REINDEX-to-change-tablespace.patch) at 2020-02-29 12:35:27 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v7-0001-Allow-REINDEX-to-change-tablespace.patch) at 2020-01-04 18:38:24 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (reindex-tablespace-v6.patch) at 2019-12-02 08:21:34 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v5-0001-Allow-REINDEX-and-REINDEX-CONCURRENTLY-to-change-tablespace.patch) at 2019-11-27 17:47:06 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v4-0001-Allow-REINDEX-and-REINDEX-CONCURRENTLY-to-change-tablespace.patch) at 2019-11-20 18:16:48 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v3-0001-Allow-REINDEX-and-REINDEX-CONCURRENTLY-to-change-.patch) at 2019-09-24 13:02:39 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-Allow-REINDEX-and-REINDEX-CONCURRENTLY-to-SET-TAB.patch) at 2019-09-18 12:46:20 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0001-Allow-REINDEX-and-REINDEX-CONCURRENTLY-to-SET-TAB.patch) at 2019-08-31 20:54:18 from a.kondratov at postgrespro.ru (Patch: Yes)
    Attachment (0001-Allow-CLUSTER-VACUUM-FULL-and-REINDEX-to-change-tablespace.patch) at 2018-12-24 11:08:43 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)

Annotations

When Who Mail Annotation
2020-12-03 01:26:39 Michael Paquier (michael-kun) From Michael Paquier <michael@paquier.xyz>
at 2020-12-03 01:19:43
Committed the grammar refactoring parts, and I did not deal with the main patch set.
History
When Who What
2021-02-04 06:39:24 Michael Paquier (michael-kun) Closed in commitfest 2021-03 with status: Committed
2021-02-04 06:39:24 Michael Paquier (michael-kun) Changed committer to michael-kun
2021-02-01 15:30:29 Alexey Kondratov (ololobus) New status: Needs review
2021-02-01 13:11:06 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2021-02-01 13:10:25 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2021-02-01 13:10:23 Masahiko Sawada (masahikosawada) New status: Needs review
2021-01-25 08:09:10 Michael Paquier (michael-kun) New status: Waiting on Author
2021-01-21 20:49:37 Alexey Kondratov (ololobus) New status: Needs review
2021-01-20 12:25:14 Michael Paquier (michael-kun) New status: Waiting on Author
2021-01-18 13:22:15 Justin Pryzby (justinpryzby) New status: Needs review
2021-01-18 05:36:47 Michael Paquier (michael-kun) New status: Waiting on Author
2021-01-06 00:41:15 Steve Singer (ssinger) Removed ssinger from reviewers
2020-12-04 14:50:27 Justin Pryzby (justinpryzby) New status: Needs review
2020-12-03 01:26:39 Michael Paquier (michael-kun) Added annotation "Committed the grammar refactoring parts, and I did not deal with the main patch set." to X8g9L7ZNymScmziJ@paquier.xyz
2020-12-03 01:24:19 Michael Paquier (michael-kun) New status: Waiting on Author
2020-12-03 01:24:14 Michael Paquier (michael-kun) Removed michael-kun from committers
2020-11-30 07:53:26 Michael Paquier (michael-kun) Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-30 07:49:00 Michael Paquier (michael-kun) Added michael-kun as committer
2020-09-30 07:49:07 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-02 20:58:33 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-05-25 03:55:22 Justin Pryzby (justinpryzby) New status: Ready for Committer
2020-04-08 16:15:06 David Steele (dsteele) Changed targetversion to None
2020-04-08 15:41:39 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-04-07 00:22:18 Justin Pryzby (justinpryzby) Changed authors to Justin Pryzby (justinpryzby), Alexey Kondratov (ololobus)
2020-04-04 02:37:23 Justin Pryzby (justinpryzby) Changed name to Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLESPACE
2020-03-27 05:12:42 Justin Pryzby (justinpryzby) Changed authors to Alexey Kondratov (ololobus)
2020-03-27 04:04:13 Justin Pryzby (justinpryzby) Changed authors to Justin Pryzby (justinpryzby), Alexey Kondratov (ololobus)
2020-03-07 04:41:55 Justin Pryzby (justinpryzby) Changed targetversion to 13
2020-03-07 04:41:55 Justin Pryzby (justinpryzby) Changed name to Allow REINDEX, CLUSTER and VACUUM FULL to SET TABLESPACE
2020-02-29 04:20:00 Justin Pryzby (justinpryzby) Added justinpryzby as reviewer
2020-02-01 12:58:41 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Moved to next CF
2020-01-31 23:39:56 Cleysson Lima (cleyssonlima) Added cleyssonlima as reviewer
2019-11-29 14:32:12 Alexey Kondratov (ololobus) New status: Needs review
2019-11-27 04:27:48 Michael Paquier (michael-kun) New status: Waiting on Author
2019-11-27 04:27:43 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-27 04:27:39 Michael Paquier (michael-kun) New status: Needs review
2019-11-27 03:54:42 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Returned with feedback
2019-11-24 01:13:13 Steve Singer (ssinger) New status: Ready for Committer
2019-11-20 18:18:38 Alexey Kondratov (ololobus) New status: Needs review
2019-11-17 00:53:27 Steve Singer (ssinger) Posted review with messageid <157395200750.29912.1178609357962324139.pgcf@coridan.postgresql.org>
2019-11-17 00:53:27 Steve Singer (ssinger) New status: Waiting on Author
2019-11-16 20:43:34 Steve Singer (ssinger) Added ssinger as reviewer
2019-09-30 19:05:59 Álvaro Herrera (alvherre) Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-18 12:48:09 Alexey Kondratov (ololobus) New status: Needs review
2019-09-18 07:53:04 Michael Paquier (michael-kun) New status: Waiting on Author
2019-08-30 17:51:54 Alexey Kondratov (ololobus) Changed authors to Alexey Kondratov (ololobus)
2019-08-30 17:51:25 Alexey Kondratov (ololobus) Attached mail thread 8a8f5f73-00d3-55f8-7583-1375ca8f6a91@postgrespro.ru
2019-08-30 17:51:25 Alexey Kondratov (ololobus) Created patch record
Edit