RE: [HACKERS] sort on huge table

Still pretty good. That's five and a half thousand rows a second.

>> -----Original Message-----
>> From: Tatsuo Ishii [mailto:t-ishii(at)sra(dot)co(dot)jp]
>> Sent: Thursday, November 04, 1999 11:10 AM
>> To: Ansley, Michael
>> Cc: 't-ishii(at)sra(dot)co(dot)jp'; Tom Lane; pgsql-hackers(at)postgreSQL(dot)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
>>
>> ************
>>