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

From Peter Eisentraut
Subject Re: [HACKERS] sort on huge table
Date
Msg-id Pine.GSO.4.02A.9911301910030.13278-100000@Vessla.DoCS.UU.SE
Whole thread Raw
In response to Re: [HACKERS] sort on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses initdb.sh fixed  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
I ran the sort script without change, the resulting file was about 250MB
in size. Not sure what kind of sizes you were looking for.

6.5.3     696.01 real         0.03 user         0.02 sys

"7.0" from last Saturday     957.73 real         0.03 user         0.02 sys
one more time     936.41 real         0.04 user         0.01 sys


FreeBSD 3.3, 200MHz Pentium (P55C), 128MB RAM
both installations where done without extras (bare ./configure)

That almost seems too wacko to be true. I'll be happy to rerun them, with
other sizes if you want.

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden







pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Ownership/protection (was Re: [HACKERS] Portability)
Next
From: Ian Macdonald
Date:
Subject: Re: [HACKERS] perl-DBD-Pg (was Re: BOUNCE pgsql-ports@postgreSQL.org: Non-member submission from[Joe Brenner ] (fwd))