Re: When do vacuumed pages/tuples become available for reuse?

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