User-Agent: Microsoft-Entourage/12.11.0.080522
Date: Mon, 21 Jul 2008 01:57:52 -0700
Subject: Re: Performance on Sun Fire X4150 x64 (dd, bonnie++,
 pgbench)
From: Luke Lonergan <llonergan@greenplum.com>
To: Stephane Bailliez <sbailliez@gmail.com>
CC: <pgsql-performance@postgresql.org>
Message-ID: <C4A99DA0.6844D%llonergan@greenplum.com>
Thread-Topic: [PERFORM] Performance on Sun Fire X4150 x64 (dd, bonnie++,
	pgbench)
Thread-Index: AcjrD0Hh/Tmjb6ziTquG5xEyv3+XnwAAJmjP
In-Reply-To: <48844E7A.9050208@gmail.com>
Mime-version: 1.0
Content-type: text/plain;
	charset="US-ASCII"
Content-transfer-encoding: 7bit

Hi Stephane,

On 7/21/08 1:53 AM, "Stephane Bailliez" <sbailliez@gmail.com> wrote:

>> I'd suggest RAID5, or even better, configure all eight disks as a JBOD
>> in the RAID adapter and run ZFS RAIDZ.  You would then expect to get
>> about 7 x 80 = 560 MB/s on your single query.
>> 
> Do you have a particular controller and disk hardware configuration in
> mind when you're suggesting RAID5 ?
> My understanding was it was more difficult to find the right hardware to
> get performance on RAID5 compared to RAID10.

If you're running RAIDZ on ZFS, the controller you have should be fine.
Just configure the HW RAID controller to treat the disks as JBOD (eight
individual disks), then make a single RAIDZ zpool of the eight disks.  This
will run them in a robust SW RAID within Solaris.  The fault management is
superior to what you would otherwise have in your HW RAID and the
performance should be much better.

- Luke