> > Hmmm ... how big *is* that varchar field? 8 characters gives us about 6mb
> > 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?
______AGLIO DATABASE SOLUTIONS___________________________
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
In response to
pgsql-performance by date
|Next:||From: Rod Taylor||Date: 2002-11-15 22:40:19|
|Subject: Re: Sort time|
|Previous:||From: Peter T. Brown||Date: 2002-11-15 20:51:18|
|Subject: can this query be made to run faster?|