public inbox for [email protected]
help / color / mirror / Atom feedFrom: Simon Riggs <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Table-Level Locks and Transactions
Date: Thu, 9 Dec 2021 12:47:47 +0000
Message-ID: <CANbhV-GA8cZo3toh+m49+_aeU46XUCgQqN5QhDvoKfY+wbbPAg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAKemG7XD-UU7AGan+jp5jtw+6wwcN4z3pPSB=DuoAC1z3JDDhg@mail.gmail.com>
<CANbhV-EyDBV_z5urPQHshMakkScUwRdfBjektEB3NYkdmc4=1g@mail.gmail.com>
<[email protected]>
On Thu, 9 Dec 2021 at 11:47, Laurenz Albe <[email protected]> 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/
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Table-Level Locks and Transactions
In-Reply-To: <CANbhV-GA8cZo3toh+m49+_aeU46XUCgQqN5QhDvoKfY+wbbPAg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox