Re: REINDEX or DROP and CREATE ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: REINDEX or DROP and CREATE ?
Date: 2003-08-17 23:54:02
Message-ID: 14228.1061164442@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Gaetano Mendola" <mendola(at)bigfoot(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chad R. Larson 2003-08-18 07:53:31 Re: Host configuration
Previous Message Gaetano Mendola 2003-08-17 22:33:24 REINDEX or DROP and CREATE ?