Skip site navigation (1) Skip section navigation (2)

Re: Sort time

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 (view raw or flat)
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


In response to

Responses

pgsql-performance by date

Next:From: Rod TaylorDate: 2002-11-15 22:40:19
Subject: Re: Sort time
Previous:From: Peter T. BrownDate: 2002-11-15 20:51:18
Subject: can this query be made to run faster?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group