Re: [HACKERS] sort on huge table

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: "Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)za>
Cc: "'t-ishii(at)sra(dot)co(dot)jp'" <t-ishii(at)sra(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] sort on huge table
Date: 1999-11-04 09:10:19
Message-ID: 199911040910.SAA04695@srapc451.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>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

Browse pgsql-hackers by date

  From Date Subject
Next Message Ansley, Michael 1999-11-04 09:12:48 RE: [HACKERS] sort on huge table
Previous Message Ansley, Michael 1999-11-04 08:53:41 RE: [HACKERS] getting new serial value of serial insert