ALTER tbl rewrite and REINDEX CONCURRENTLY lose CLUSTER property

Edit

Title

Topic

Bug Fixes

Created

2020-02-27 00:25:13

Last modified

2020-04-06 02:48:21 (4 years ago)

Latest email

2020-04-06 02:47:57 (4 years ago)

Status

2020-03: 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