On Fri, 2002-11-15 at 16:18, Josh Berkus wrote:
> > > 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?
I'd suspect the total row is sorted, especially in this case where he's
sorting more than one attribute.
Rod Taylor <rbt(at)rbt(dot)ca>
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2002-11-15 23:02:15|
|Subject: ANALYZE and indexes (was Re: Sort time)|
|Previous:||From: Josh Berkus||Date: 2002-11-15 21:18:33|
|Subject: Re: Sort time|