"Gaetano Mendola" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
