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 47759D9F15;
	Mon,  3 Oct 2005 17:30:14 -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 27426-06; Mon,  3 Oct 2005 20:30:09 +0000 (GMT)
Received: from davinci.ethosmedia.com (server227.ethosmedia.com
	[209.128.84.227])
	by svr1.postgresql.org (Postfix) with ESMTP id 14128D9F0B;
	Mon,  3 Oct 2005 17:30:09 -0300 (ADT)
X-EthosMedia-Virus-Scanned: no infections found
Received: from [64.81.245.111] (account josh@agliodbs.com HELO
	temoku.sf.agliodbs.com)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8)
	with ESMTP id 8192091; Mon, 03 Oct 2005 13:32:35 -0700
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] A Better External Sort?
Date: Mon, 3 Oct 2005 13:34:01 -0700
User-Agent: KMail/1.8
Cc: Michael Stone <mstone+postgres@mathom.us>,
 pgsql-performance@postgresql.org
References: 
 <31833713.1128111650174.JavaMail.root@elwamui-polski.atl.sa.earthlink.net>
	<200509301341.22795.josh@agliodbs.com>
	<20050930231032.GQ2241@mathom.us>
In-Reply-To: <20050930231032.GQ2241@mathom.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200510031334.02030.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.046 required=5 tests=[AWL=-0.004,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200510/24
X-Sequence-Number: 14792

Michael,

> >Realistically, you can't do better than about 25MB/s on a
> > single-threaded I/O on current Linux machines,
>
> What on earth gives you that idea? Did you drop a zero?

Nope, LOTS of testing, at OSDL, GreenPlum and Sun.   For comparison, A 
Big-Name Proprietary Database doesn't get much more than that either.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco