| From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] sort on huge table |
| Date: | 1999-11-30 20:19:54 |
| Message-ID: | Pine.GSO.4.02A.9911301910030.13278-100000@Vessla.DoCS.UU.SE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Macdonald | 1999-12-01 00:03:57 | Re: [HACKERS] perl-DBD-Pg (was Re: BOUNCE pgsql-ports@postgreSQL.org: Non-member submission from[Joe Brenner <doom@kzsu.stanford.edu>] (fwd)) |
| Previous Message | Peter Eisentraut | 1999-11-30 19:36:01 | Re: Ownership/protection (was Re: [HACKERS] Portability) |