Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group