Hi hackers! Recently Kirill and I have faced several problems with pg_repack, that resulted in list of invalid indexes on our installations, and that required us to remove them ourselves.
We thought that it might be useful to have a command in PG, that removes invalid indexes on specified table automatically, to reduce the chances of any human-related mistakes. So we implemented a new command which usage looks like: postgres=# drop invalid indexes on table sas; NOTICE: dropping index "idx2" NOTICE: dropping index "idx5" DROP INVALID INDEXES postgres=# We would like to know if this feature would be acceptable for upstream inclusion. POC patch attached, any feedback on the design and implementation is welcome :) -- Best regards, Roman Khapov
0001-Add-DROP-INVALID-INDEXES-ON-TABLE-command.patch
Description: Binary data
