X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A8AF0DA215;
	Wed,  5 Oct 2005 15:30:41 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 43691-10; Wed,  5 Oct 2005 18:30:33 +0000 (GMT)
Received: from gghcwest.com (adsl-71-128-90-172.dsl.pltn13.pacbell.net
	[71.128.90.172])
	by svr1.postgresql.org (Postfix) with ESMTP id 93CEFDA283;
	Wed,  5 Oct 2005 15:30:31 -0300 (ADT)
Received: from toonses.gghcwest.com (toonses.gghcwest.com [192.168.168.115])
	by gghcwest.com (8.12.10/8.12.9) with ESMTP id j95IUKmd027940;
	Wed, 5 Oct 2005 11:30:21 -0700
Received: from jwb by toonses.gghcwest.com with local (Exim 4.52)
	id 1ENE21-00018H-Hs; Wed, 05 Oct 2005 11:30:21 -0700
Subject: Re: [HACKERS] A Better External Sort?
From: "Jeffrey W. Baker" <jwbaker@acm.org>
To: Ron Peacetree <rjpeace@earthlink.net>
Cc: Luke Lonergan <LLonergan@greenplum.com>,
	pgsql-hackers@postgresql.org, pgsql-performance@postgresql.org
In-Reply-To: 
 <4579585.1128528861232.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>
References: 
 <4579585.1128528861232.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: Wed, 05 Oct 2005 11:30:21 -0700
Message-Id: <1128537021.3963.1.camel@toonses.gghcwest.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.4.1 
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=-0.319 required=5 tests=[AWL=-0.369,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200510/111
X-Sequence-Number: 14879

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