Thread: RE: [HACKERS] sort on huge table

RE: [HACKERS] sort on huge table

From
"Ansley, Michael"
Date:
Still pretty good.  That's five and a half thousand rows a second.

>> -----Original Message-----
>> From: Tatsuo Ishii [mailto:t-ishii@sra.co.jp]
>> Sent: Thursday, November 04, 1999 11:10 AM
>> To: Ansley, Michael
>> Cc: 't-ishii@sra.co.jp'; Tom Lane; pgsql-hackers@postgreSQL.org
>> Subject: Re: [HACKERS] sort on huge table 
>> 
>> 
>> >Now that's a close to linear as you are going to get.  
>> Pretty good I think:
>> >a sort of one billion rows in half an hour.
>> 
>> Oops! It's not one billion but 10 millions. Sorry.
>> 
>> 1 million tuples    1:31
>> 2            4:24
>> 3            7:27
>> 4            11:11  <-- 970MB
>> 5            14:01  <-- 1.1GB (segmented files)
>> 6            18:31
>> 7            22:24
>> 8            24:36
>> 9            28:12
>> 10            32:14
>> --
>> Tatsuo Ishii
>> 
>> ************
>>