| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | josh(at)agliodbs(dot)com |
| Cc: | pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Sort time |
| Date: | 2002-11-15 19:28:39 |
| Message-ID: | 1037388518.14810.118.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)rbt(dot)ca>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2002-11-15 20:09:31 | Re: can this query be made to run faster? |
| Previous Message | Josh Berkus | 2002-11-15 19:27:29 | Re: Sort time |