Re: WIP: further sorting speedup

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WIP: further sorting speedup
Дата
Msg-id 23828.1140718532@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WIP: further sorting speedup  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: WIP: further sorting speedup  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-patches
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> On Wed, Feb 22, 2006 at 10:18:48PM -0500, Tom Lane wrote:
>> The Datum is just a pointer into the original tuple in that case.

> That would still result in a speedup since you don't have to figure out
> where the field begins though, right? I'm curious as to how much this
> patch would help with sorting text...

Right.  It would help just as much as in the integer case as far as
eliminating the time spent in heap_getattr is concerned.  That would be
a smaller percentage of the whole, because bttextcmp is (a lot) slower
than btint4cmp, but that's no fault of the patch.

            regards, tom lane

В списке pgsql-patches по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: WIP: further sorting speedup
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: WIP: further sorting speedup