On Thu, 9 Dec 2021 at 11:47, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > Have you thought about using DROP INDEX CONCURRENTLY and CREATE INDEX
> > CONCURRENTLY?
>
> These cannot be used in a transaction, however.
True, but they don't need to be for this case.
If this is the same index, look at REINDEX CONCURRENTLY.
--
Simon Riggs http://www.EnterpriseDB.com/