RE: [HACKERS] sort on huge table - Mailing list pgsql-hackers

From Ansley, Michael
Subject RE: [HACKERS] sort on huge table
Date
Msg-id 1BF7C7482189D211B03F00805F8527F748C20A@S-NATH-EXCH2
Whole thread Raw
List pgsql-hackers
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
>> 
>> ************
>> 


pgsql-hackers by date:

Previous
From: "Ansley, Michael"
Date:
Subject: RE: [HACKERS] getting new serial value of serial insert
Next
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] PostgreSQL 6.5.3 built, but not released ...