Re: sequence indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: sequence indexes
Date
Msg-id 6862.1011996346@sss.pgh.pa.us
Whole thread Raw
In response to sequence indexes  (Vince Vielhaber <vev@michvhf.com>)
List pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
>> I've looked at the problem a little bit --- there's literature more
>> recent than Lehmann-Yao that talks about how to do btree compaction
>> without losing concurrency.  But it didn't get done for 7.2.

> Yes, there must be. Informix handles this case perfectly.
> (It uses a background btree cleaner)

Right, I had hoped to fold it into lazy VACUUM, but ran out of time.
(Of course, had I known in August that we'd still not have released
7.2 by now, I might have kept after it :-()
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Savepoints
Next
From: Bill Studenmund
Date:
Subject: Re: RFD: schemas and different kinds of Postgres objects