"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