Unexpected reindex when altering column types for partitioned tables

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 3, First patch: +74−0, All patches: +157−42

Tags

DDL Performance

Created

2026-06-15 12:52:22

Last modified

2026-08-05 09:14:15 (1 hour ago)

Latest email

2026-06-16 11:24:59 (1 month ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Needs review

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

Target version

Authors

Álvaro Rodríguez (arodrgr)

Reviewers

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-06-16 11:24:59 by Álvaro Rodríguez <alvaro at datadoghq.com>
Latest 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>
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-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