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, 9 months ago)

Latest email 2021-02-15 02:58:02 (3 years, 9 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