Re: How to rebuild index efficiently

> On Aug 3, 2020, at 10:20, Konireddy Rajashekar <rajkonireddy@gmail.com> wrote:
> Could you please suggest any ideal approach to tackle this ?

You can do CREATE INDEX CONCURRENTLY to build a new index with the same definition, and when that is complete, drop the
oldindex.  The locking that is required here is modest: CREATE INDEX CONCURRENTLY needs to lock the table briefly at a
coupleof points in the operation, and dropping the old index requires a brief lock on the table.  It is, however, much
lessoverall lock time than REINDEX would be. 

--
-- Christophe Pettus
   xof@thebuild.com