Re: Block B-Tree concept - Mailing list pgsql-hackers

From Csaba Nagy
Subject Re: Block B-Tree concept
Date
Msg-id 1159368006.3874.171.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: Block B-Tree concept  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Block B-Tree concept
List pgsql-hackers
> > I think you build a whole new index named something like ".temp-reindex" and
> > then as the last step of the second transaction delete the old idnex and
> > rename the new index.
> 
> That would require getting exclusive lock on the table.

Just out of curiosity, creating a new index concurrently (or online,
whatever you call it) doesn't require to set an exclusive lock on the
table ? I thought it would, at least swiftly at the end of the
operation, after all it's modifying the table...

Cheers,
Csaba.




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql service parameter
Next
From: "Albe Laurenz"
Date:
Subject: Re: psql service parameter