Tom Lane wrote:
> Alvaro Herrera <alvherre@atentus.com> writes:
>
>>Whereas the DROP INDEX/CREATE INDEX method works on-the-fly. You may end
>>up running a seqscan somewhere, but that's not so big a problem, IMHO.
>>
>
> True, that way doesn't lock out concurrent readers of the table while
> the index is rebuilt.
Have the locking issues with reindex been resolved in 7.1.3?
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com