Postgres Pro
Downloads
Home   >   mailing lists

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

From Tatsuo Ishii
Subject Re: [HACKERS] sort on huge table
Date
Msg-id 199911040910.SAA04695@srapc451.sra.co.jp
Whole thread Raw
In response to RE: [HACKERS] sort on huge table  ("Ansley, Michael" <Michael.Ansley@intec.co.za>)
Responses Re: [HACKERS] sort on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
>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] sort on huge table
Next
From: "Ansley, Michael"
Date:
Subject: RE: [HACKERS] getting new serial value of serial insert