Re: B-Tree index builds, CLUSTER, and sortsupport - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: B-Tree index builds, CLUSTER, and sortsupport
Date
Msg-id 545A51F2.1070301@BlueTreble.com
Whole thread Raw
In response to B-Tree index builds, CLUSTER, and sortsupport  (Peter Geoghegan <pg@heroku.com>)
Responses Re: B-Tree index builds, CLUSTER, and sortsupport  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
On 10/10/14, 7:26 PM, Peter Geoghegan wrote:
> Both Robert and Heikki expressed dissatisfaction with the fact that
> B-Tree index builds don't use sortsupport. Because B-Tree index builds
> cannot really use the "onlyKey" optimization, the historic oversight
> of not supporting B-Tree builds (and CLUSTER) might have been at least
> a little understandable [1]. But with the recent work on sortsupport
> for text, it's likely that B-Tree index builds will be missing out on
> rather a lot by not taking advantage of sortsupport.
>
> Attached patch modifies tuplesort to correct this oversight. What's
> really nice about it is that there is actually a net negative code
> footprint:

Did anything ever happen with this?
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: tracking commit timestamps
Next
From: Andres Freund
Date:
Subject: Re: tracking commit timestamps