"Markus Bertheau" <mbertheau.pg@googlemail.com> writes:
> 2008/2/29, Tom Lane <tgl@sss.pgh.pa.us>:
>> 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
