From: Jeffrey W. Baker <jwbaker@acm.org>
To: Ron Peacetree <rjpeace@earthlink.net>
Cc: Luke Lonergan <LLonergan@greenplum.com>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [HACKERS] A Better External Sort?
Date: Wed, 05 Oct 2005 11:30:21 -0700
Message-ID: <1128537021.3963.1.camel@toonses.gghcwest.com> (raw)
In-Reply-To: <4579585.1128528861232.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>
References: <4579585.1128528861232.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jwbaker@acm.org, rjpeace@earthlink.net, LLonergan@greenplum.com, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] A Better External Sort?
In-Reply-To: <1128537021.3963.1.camel@toonses.gghcwest.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox