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
signature.asc
Description: PGP signature
