ALTER tbl rewrite and REINDEX CONCURRENTLY lose CLUSTER property

Edit
ID 2481
Title ALTER tbl rewrite and REINDEX CONCURRENTLY lose CLUSTER property
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Bug Fixes
Tags
Created 2020-02-27 00:25:13
Last modified 2020-04-06 02:48:21 (5 years ago)
Latest email 2020-04-06 02:47:57 (5 years ago)
Status
2020-03 (2020-03-01 – 2020-03-31): Committed
Target version stable
Authors Amit Langote (amitlan)
Reviewers Ibrar Ahmed (ibrar)Become reviewer
Committer Michael Paquier (michael-kun)
Links
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