Postgres Pro
Downloads
Home   >   mailing lists

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

From Gaetano Mendola
Subject REINDEX or DROP and CREATE ?
Date
Msg-id 02f101c3650f$926ede00$10d4a8c0@mm.eutelsat.org
Whole thread Raw
Responses Re: REINDEX or DROP and CREATE ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Hi all,
what the difference ( apart a windows without index ) between
REINDEX a TABLE
or
DROP each index and CREATE it again?

I'm worried about the type of locks involved.


Regards
Gaetano Mendola

pgsql-admin by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: Time event
Next
From: Tom Lane
Date:
Subject: Re: REINDEX or DROP and CREATE ?