On Thu, Apr 11, 2019 at 10:39:12PM -0600, Michael Lewis wrote:
> You can create (concurrently) an identical index with a new name, then drop
> old version concurrently and repeat for each. It doesn't help you figure
> out the root cause and how to prevent it from happening again, but gets you
> to a fresh start at least.
Please note that Postgres 12 has added support for REINDEX
concurrently. A huge advantage of that is the possibility to work on
indexes with constraints.
--
Michael