Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench)

From: Luke Lonergan <llonergan(at)greenplum(dot)com>
To: Stephane Bailliez <sbailliez(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench)
Date: 2008-07-21 08:57:52
Message-ID: C4A99DA0.6844D%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Stephane,

On 7/21/08 1:53 AM, "Stephane Bailliez" <sbailliez(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Stephane Bailliez 2008-07-21 10:11:57 Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench)
Previous Message Stephane Bailliez 2008-07-21 08:53:14 Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench)