Re: WIP: further sorting speedup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-patches(at)postgreSQL(dot)org
Subject: Re: WIP: further sorting speedup
Date: 2006-02-23 18:15:32
Message-ID: 23828.1140718532@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

"Jim C. Nasby" <jnasby(at)pervasive(dot)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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Jim C. Nasby 2006-02-24 00:05:00 Re: WIP: further sorting speedup
Previous Message Jim C. Nasby 2006-02-23 18:07:02 Re: WIP: further sorting speedup