Re: RAID Controller (HP P400) beat by SW-RAID? - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: RAID Controller (HP P400) beat by SW-RAID?
Date
Msg-id CAOR=d=3ORcmuj5iBuQ0tA69SnGOVKu6pLKindccv+dM7VFSkbA@mail.gmail.com
Whole thread Raw
In response to RAID Controller (HP P400) beat by SW-RAID?  (Anthony Presley <anthony@resolution.com>)
List pgsql-performance
On Sun, Sep 11, 2011 at 4:44 PM, Anthony Presley <anthony@resolution.com> wrote:
> We've currently got PG 8.4.4 running on a whitebox hardware set up, with (2)
> 5410 Xeon's, and 16GB of RAM.  It's also got (4) 7200RPM SATA drives, using
> the onboard IDE controller and ext3.
> A few weeks back, we purchased two refurb'd HP DL360's G5's, and were hoping
> to set them up with PG 9.0.2, running replicated.  These machines have (2)
> 5410 Xeon's, 36GB of RAM, (6) 10k SAS drives, and are using the HP SA P400i
> with 512MB of BBWC.  PG is running on an ext4 (noatime) partition, and they

Two issues here.  One is that the onboard controller and disks on the
old machine might not be obeying fsync properly, giving a speed boost
at the expense of crash safeness.  Two is that the P400 has gotten
pretty horrible performance reviews on this list in the past.

pgsql-performance by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: RAID Controller (HP P400) beat by SW-RAID?
Next
From: Stephen Frost
Date:
Subject: Re: Postgres for a "data warehouse", 5-10 TB