Re: Table-Level Locks and Transactions - Mailing list pgsql-novice

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/