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
|
Список | 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 по дате отправления: