Re: B-Tree index builds, CLUSTER, and sortsupport

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: B-Tree index builds, CLUSTER, and sortsupport
Дата
Msg-id 545A51F2.1070301@BlueTreble.com
обсуждение исходный текст
Ответ на B-Tree index builds, CLUSTER, and sortsupport  (Peter Geoghegan <pg@heroku.com>)
Ответы Re: B-Tree index builds, CLUSTER, and sortsupport  (Peter Geoghegan <pg@heroku.com>)
Список 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 по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: tracking commit timestamps
Следующее
От: Andres Freund
Дата:
Сообщение: Re: tracking commit timestamps