ALTER tbl rewrite and REINDEX CONCURRENTLY lose CLUSTER property

Edit
Comment/Review
Change Status
ID 2481
Title ALTER tbl rewrite and REINDEX CONCURRENTLY lose CLUSTER property
Topic Bug Fixes
Created 2020-02-27 00:25:13
Last modified 2020-04-06 02:48:21 (4 years, 7 months ago)
Latest email 2020-04-06 02:47:57 (4 years, 7 months ago)
Status
2020-03: Committed
Target version stable
Authors Amit Langote (amitlan)
Reviewers Ibrar Ahmed (ibrar)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/2481
git checkout commitfest/cf/2481
Emails
ALTER tbl rewrite loses CLUSTER ON index
First at 2020-02-02 16:17:18 by Justin Pryzby <pryzby at telsasoft.com>
Latest at 2020-04-06 02:47:57 by Michael Paquier <michael at paquier.xyz>
Latest attachment (v8-0001-Preserve-clustered-indexes-after-rewrites-of-ALTE.patch) at 2020-04-02 06:14:21 from Michael Paquier <michael at paquier.xyz>
    Attachment (v8-0001-Preserve-clustered-indexes-after-rewrites-of-ALTE.patch) at 2020-04-02 06:14:21 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v7-0001-ALTER-tbl-rewrite-loses-CLUSTER-ON-index.patch) at 2020-03-16 13:27:31 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v6-0001-ALTER-tbl-rewrite-loses-CLUSTER-ON-index.patch) at 2020-03-16 07:01:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-ALTER-tbl-rewrite-loses-CLUSTER-ON-index.patch) at 2020-03-03 01:36:25 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v4-0001-ALTER-tbl-rewrite-loses-CLUSTER-ON-index.patch) at 2020-02-29 16:52:58 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v1-0001-Update-comment-obsolete-since-b9b8831a.patch) at 2020-02-07 14:39:35 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (preserve-CLUSTER-ON-during-ALTER-TABLE_v3.patch) at 2020-02-06 09:14:16 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (preserve-CLUSTER-ON-during-ALTER-TABLE.patch) at 2020-02-05 06:53:45 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-preserve-CLUSTER-ON-during-ALTER-TABLE.patch) at 2020-02-02 16:17:18 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)

Annotations

When Who Mail Annotation
2020-03-03 05:03:19 Michael Paquier (michael-kun) From Michael Paquier <michael@paquier.xyz>
at 2020-03-03 01:14:06		 Committed the part about REINDEX CONCURRENTLY, and did not look at the other one.
History
When Who What
2020-04-06 02:48:21 Michael Paquier (michael-kun) Closed in commitfest 2020-03 with status: Committed
2020-04-03 07:11:11 Michael Paquier (michael-kun) Added michael-kun as committer
2020-03-12 17:20:14 Tom Lane (tgl) New status: Waiting on Author
2020-03-05 20:21:51 Justin Pryzby (justinpryzby) Changed authors to Amit Langote (amitlan)
2020-03-05 20:11:14 Ibrar Ahmed (ibrar) Added ibrar as reviewer
2020-03-05 20:11:10 Ibrar Ahmed (ibrar) Posted review with messageid <158343907083.14910.4432292799617573119.pgcf@coridan.postgresql.org>
2020-03-05 20:11:10 Ibrar Ahmed (ibrar) New status: Ready for Committer
2020-03-03 05:03:19 Michael Paquier (michael-kun) Added annotation "Committed the part about REINDEX CONCURRENTLY, and did not look at the other one." to 20200303011406.GF32059@paquier.xyz
2020-02-29 17:06:15 Justin Pryzby (justinpryzby) Changed name to ALTER tbl rewrite and REINDEX CONCURRENTLY lose CLUSTER property
2020-02-29 16:54:08 Justin Pryzby (justinpryzby) Changed authors to Amit Langote (amitlan), Justin Pryzby (justinpryzby)
2020-02-29 16:53:32 Justin Pryzby (justinpryzby) Deleted annotation "Amit's v3 patch seems to be the correct fix" from CA+HiwqEt1HnXYckCdaO8+pOoFs7NNS5byoZ6Xg2B7epKbhS85w@mail.gmail.com
2020-02-27 00:29:46 Justin Pryzby (justinpryzby) Added annotation "Amit's v3 patch seems to be the correct fix" to CA+HiwqEt1HnXYckCdaO8+pOoFs7NNS5byoZ6Xg2B7epKbhS85w@mail.gmail.com
2020-02-27 00:27:17 Justin Pryzby (justinpryzby) Changed authors to Amit Langote (amitlan)
2020-02-27 00:27:17 Justin Pryzby (justinpryzby) Changed targetversion to stable
2020-02-27 00:25:13 Justin Pryzby (justinpryzby) Attached mail thread 20200202161718.GI13621@telsasoft.com
2020-02-27 00:25:13 Justin Pryzby (justinpryzby) Created patch record
Edit
Comment/Review
Change Status