Re: Sort time

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@agliodbs.com
    and data management solutions     (415) 565-7293
   for law firms, small businesses      fax 621-2533
    and non-profit organizations.     San Francisco