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

From Simon Riggs
Subject Re: Table-Level Locks and Transactions
Date
Msg-id CANbhV-GA8cZo3toh+m49+_aeU46XUCgQqN5QhDvoKfY+wbbPAg@mail.gmail.com
Whole thread Raw
In response to Re: Table-Level Locks and Transactions  (Laurenz Albe <laurenz.albe@cybertec.at>)
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/



pgsql-novice by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Table-Level Locks and Transactions
Next
From: Greg Rychlewski
Date:
Subject: Streaming Replication Protocol and Logical Replication