REINDEX or DROP and CREATE ?

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: REINDEX or DROP and CREATE ?
Date: 2003-08-17 22:33:24
Message-ID: 02f101c3650f$926ede00$10d4a8c0@mm.eutelsat.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-08-17 23:54:02 Re: REINDEX or DROP and CREATE ?
Previous Message Stephan Szabo 2003-08-16 21:25:41 Re: Hello Testing