Hi all,
I have been working on another patch [0] and was pointed to this
thread. My changes are focused on avoiding preventable rebuilds of the
leaf indexes on partitioned tables, when we do ALTER TABLE ALTER
COLUMN TYPE. I change the order in which indexes are processed and do
some other minor changes to ensure that they are correctly remembered
on rebuild.
I believe commit 0003 here addresses a subset of the issues that my
patch fixes. To validate, I have combined 0001 + 0002 + my patch +
0003's tests and the tests seem to be passing (the only change in test
output is the at_partitioned test, where I get the storage changes
that my patch is fixing). Commits 0001 and 0002 are not addressed by
my patch at all, as far as I can tell. I wonder if it's worth joining
efforts!
Best,
Álvaro
[0]
https://www.postgresql.org/message-id/flat/CA%2BC_kKX9Qk0JQZ%2BbjyHWNiCBLYN4kyCRdJoJ%2Bgtr1K2%2BXjo55g%40mail.gmail.com
