Re: Sort time - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Sort time
Date
Msg-id 1037388518.14810.118.camel@jester
Whole thread Raw
In response to Re: Sort time  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Sort time  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On Fri, 2002-11-15 at 14:27, Josh Berkus wrote:
> > The big problem is he's sorting by a varchar() which isn't overly quick
> > no matter what locale.  Integers are nice and quick (s.OP is an int,
> > which shows this).
> >
> > If IDS_NUM is a number, he could try casting it to an int8, but without
> > data examples I couldn't say.
>
> Hmmm ... how big *is* that varchar field?  8 characters gives us about 6mb for
> the column.  Of course, if it's a 128-char global unque id, that;s a bit
> larger.

20 characters long in the Unicode locale -- which is 40 bytes?
--
Rod Taylor <rbt@rbt.ca>

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: can this query be made to run faster?
Next
From: Josh Berkus
Date:
Subject: Re: Sort time