Just to +1 this as a non-Postgres-user who briefly skimmed the docs: REINDEX INDEX CONCURRENTLY ^ it can be rebuilt. I'm honestly not sure if this is sav

Just to +1 this as a non-Postgres-user who briefly skimmed the docs: REINDEX INDEX CONCURRENTLY ^ it can be rebuilt. I'm honestly not sure if this is saving anything except re-defining (i.e. the literal "create index" statement), but they seem definitely not 100% useless despite being invalid. Maybe 99% useless, but "drop it in the background" doesn't seem particularly better either - leaving intermediate state for an admin to tackle by hand seems reasonable.