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