"Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> writes:
> On 2 Sep 2003 at 10:19, Vivek Khera wrote:
>> Reindexing a table takes an exclusive table lock.
> Well, you donm't need to reindex as such. You can create a new index from
> scratch and drop the old one inside a transaction.
> That will be perfectly non-blocking I believe..
It still blocks updates to the table while the new index is being built.
regards, tom lane