Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX or DROP and CREATE ? - Mailing list pgsql-admin

From Tom Lane
Subject Re: REINDEX or DROP and CREATE ?
Date
Msg-id 14228.1061164442@sss.pgh.pa.us
Whole thread Raw
In response to REINDEX or DROP and CREATE ?  ("Gaetano Mendola" <mendola@bigfoot.com>)
List pgsql-admin
Tree view 
"Gaetano Mendola" <mendola@bigfoot.com> writes:
> what the difference ( apart a windows without index ) between
> REINDEX a TABLE
> or DROP each index and CREATE it again?

Not much.

> I'm worried about the type of locks involved.

I'm pretty sure either course will take an exclusive lock on the table.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: REINDEX or DROP and CREATE ?
Next
From: "Anagha Joshi"
Date:
Subject: Connection Timeout