Unexpected reindex when altering column types for partitioned tables

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v5, Patch count: 3, First patch: +158−0, All patches: +257−48

Tags

DDL Performance

Created

2026-06-15 12:52:22

Last modified

2026-10-01 00:00:09 (1 week ago)

Latest email

2026-10-06 11:23:18 (3 days ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Waiting on Author

PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF

PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF

Target version

Authors

Álvaro Rodríguez (arodrgr)

Reviewers

Alberto Piai (albe) Become reviewer

Committer

Links

Emails

Unexpected reindex when altering column types for partitioned tables: First at 2026-06-08 13:50:40 by Álvaro Rodríguez <alvaro at datadoghq.com>
Latest at 2026-10-06 11:23:18 by Álvaro Rodríguez <alvaro at datadoghq.com>
Latest attachment (v5-0001-Add-regression-test-to-highlight-unexpected-behav.patch) at 2026-10-06 11:23:18 from Álvaro Rodríguez <alvaro at datadoghq.com>
    Attachment (v5-0001-Add-regression-test-to-highlight-unexpected-behav.patch) at 2026-10-06 11:23:18 from Álvaro Rodríguez <alvaro at datadoghq.com> (Patch: No)
    Attachment (v4-0001-Add-regression-test-to-highlight-unexpected-behav.patch) at 2026-09-18 19:59:15 from Álvaro Rodríguez <alvaro at datadoghq.com> (Patch: No)
    Attachment (v3-0001-Add-regression-test-to-highlight-unexpected-behav.patch) at 2026-09-17 20:25:35 from Álvaro Rodríguez <alvaro at datadoghq.com> (Patch: No)
    Attachment (v2-0002-Skip-index-rewriting-when-possible-on-ALTER-TABLE.patch) at 2026-06-16 11:24:59 from Álvaro Rodríguez <alvaro at datadoghq.com> (Patch: Yes)
    Attachment (v1-0001-Add-regression-test-to-highlight-unexpected-behav.patch) at 2026-06-08 13:50:40 from Álvaro Rodríguez <alvaro at datadoghq.com> (Patch: Yes)

History

When	Who	What
2026-10-01 00:00:09	CFbot	Moved from CF PG20-2 to CF PG20-3
2026-09-18 20:04:32	CFbot	Patch does not need rebase anymore
2026-09-16 16:59:22	Alberto Piai (albe)	New status: Waiting on Author
2026-09-14 20:05:14	Alberto Piai (albe)	Added albe as reviewer
2026-08-10 14:19:30	CFbot	Patch needs rebase
2026-08-05 09:14:15	Álvaro Rodríguez (arodrgr)	Moved from CF PG20-1 to CF PG20-2
2026-06-15 12:52:22	Álvaro Rodríguez (arodrgr)	Attached mail thread CA+C_kKUS0QtMT1sHW067z=CAEDLOysAy6PiwvTx9QPBifHmR5w@mail.gmail.com
2026-06-15 12:52:22	Álvaro Rodríguez (arodrgr)	Created patch record