X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id A68F39DCA3F
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 21 Mar 2006 13:59:20 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 27593-06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 21 Mar 2006 13:59:19 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from noel.decibel.org (noel.decibel.org [67.100.216.10])
	by postgresql.org (Postfix) with ESMTP id 94FBA9DCB32
	for <pgsql-performance@postgresql.org>;
	Tue, 21 Mar 2006 13:59:18 -0400 (AST)
Received: by noel.decibel.org (Postfix, from userid 1001)
	id A446E56431; Tue, 21 Mar 2006 11:59:01 -0600 (CST)
Received: (hashcash-sendmail, from uid 1001); Tue, 21 Mar 2006 11:59:01 -0600
Date: Tue, 21 Mar 2006 11:59:01 -0600
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: Miguel <mmiranda@123.com.sv>,
	Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB &
Message-ID: <20060321175900.GH15742@pervasive.com>
References: <20060321114937.GL15742@pervasive.com>
	<C0455AD3.1FA81%llonergan@greenplum.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <C0455AD3.1FA81%llonergan@greenplum.com>
X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.11
X-Hashcash: 
 1:20:060321:llonergan@greenplum.com::6jDuNLrQ5tmnE9zG:00000000000000
	0000000000000000000000000ait
X-Hashcash: 
 1:20:060321:mmiranda@123.com.sv::5PmoHXdok2feuk9f:000000000000000000
	0000000000000000000000000GJ4
X-Hashcash: 
 1:20:060321:pgsql-performance@postgresql.org::zuqW+5oKRpCDCQaB:00000
	00000000000000000000000071Q4
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108]
X-Spam-Score: 0.108
X-Spam-Level: 
X-Archive-Number: 200603/415
X-Sequence-Number: 17852

On Tue, Mar 21, 2006 at 07:25:07AM -0800, Luke Lonergan wrote:
> Jim,
> 
> On 3/21/06 3:49 AM, "Jim C. Nasby" <jnasby@pervasive.com> wrote:
> 
> > No, I don't know why the transfer rates for the mirror are 1/2 that as the raw
> > device. :(
> 
> Well - lessee.  Would those drives be attached to a Silicon Image (SII) SATA
> controller?  A Highpoint?
> 
> I found in testing about 2 years ago that under Linux (looks like you're
> BSD), most SATA controllers other than the Intel PIIX are horribly broken
> from a performance standpoint, probably due to bad drivers but I'm not sure.
> 
> Now I think whatever is commonly used by Nforce 4 implementations seems to
> work ok, but we don't count on them for RAID configurations yet.

atapci1: <nVidia nForce4 SATA150 controller>

And note that this is using FreeBSD gmirror, not the built-in raid
controller.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461