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

From Tom Lane
Subject Re: Block B-Tree concept
Date
Msg-id 8809.1159367421@sss.pgh.pa.us
Whole thread Raw
In response to Re: Block B-Tree concept  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Block B-Tree concept  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> 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.

> 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Block B-Tree concept
Next
From: Tom Lane
Date:
Subject: Re: psql service parameter