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

From Tom Lane
Subject Re: Block B-Tree concept
Date
Msg-id 27160.1159289005@sss.pgh.pa.us
Whole thread Raw
In response to Re: Block B-Tree concept  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Block B-Tree concept  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Also, now that we have concurrent CREATE INDEX, we could implement 
> concurrent REINDEX as well, I believe.

That's probably more easily said than done --- in particular, I don't
understand what the committed state after the first transaction would
look like.  CREATE INDEX can get away with it because nothing need be
depending on the new index, but you can't say that for an existing index
(esp. if it's UNIQUE).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jeff Frost
Date:
Subject: Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues
Next
From: Jeff Frost
Date:
Subject: Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues