"Markus Bertheau" <[EMAIL PROTECTED]> writes:
> 2008/2/29, Tom Lane <[EMAIL PROTECTED]>:
>> No. When you commit the reindex, the old copy of the index will
>> instantaneously disappear; it will not do for someone to be actively
>> scanning that copy.
> Can a shared lock be taken at first, and when the new index is ready,
> in order to delete the old index, elevate that lock to an exclusive
> one?
You could try, but lock upgrades are generally a recipe for increasing
your risk of deadlock failure.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
