From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Rod Taylor <rbt(at)rbt(dot)ca> |
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 21:18:33 |
Message-ID: | 200211151318.33245.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Rod,
> > 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?
Well, 40+, probably about 43. Should be about 29mb, yes?
Here's a question: is the total size of the column a good indicator of the
sort_mem required? Or does the rowsize affect it somehow?
--
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2002-11-15 22:40:19 | Re: Sort time |
Previous Message | Peter T. Brown | 2002-11-15 20:51:18 | can this query be made to run faster? |