From: | "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org> |
---|---|
To: | Ron Peacetree <rjpeace(at)earthlink(dot)net> |
Cc: | Luke Lonergan <LLonergan(at)greenplum(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: [HACKERS] A Better External Sort? |
Date: | 2005-10-05 18:30:21 |
Message-ID: | 1128537021.3963.1.camel@toonses.gghcwest.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
On Wed, 2005-10-05 at 12:14 -0400, Ron Peacetree wrote:
> I've now gotten verification from multiple working DBA's that DB2, Oracle, and
> SQL Server can achieve ~250MBps ASTR (with as much as ~500MBps ASTR in
> setups akin to Oracle RAC) when attached to a decent (not outrageous, but
> decent) HD subsystem...
>
> I've not yet had any RW DBA verify Jeff Baker's supposition that ~1GBps ASTR is
> attainable. Cache based bursts that high, yes. ASTR, no.
I find your tone annoying. That you do not have access to this level of
hardware proves nothing, other than pointing out that your repeated
emails on this list are based on supposition.
If you want 1GB/sec STR you need:
1) 1 or more Itanium CPUs
2) 24 or more disks
3) 2 or more SATA controllers
4) Linux
Have fun.
-jwb
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-10-05 18:30:47 | Re: Fwd: 8.1beta2 vacuum analyze hanging on idle database |
Previous Message | Tom Lane | 2005-10-05 18:27:32 | Re: Fwd: 8.1beta2 vacuum analyze hanging on idle database |
From | Date | Subject | |
---|---|---|---|
Next Message | Steinar H. Gunderson | 2005-10-05 18:34:41 | Re: Text/Varchar performance... |
Previous Message | Cristian Prieto | 2005-10-05 18:21:35 | Text/Varchar performance... |