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

From Stephen Frost
Subject Re: RAID Controller (HP P400) beat by SW-RAID?
Date
Msg-id 20110911225121.GM12765@tamriel.snowman.net
Whole thread Raw
In response to RAID Controller (HP P400) beat by SW-RAID?  (Anthony Presley <anthony@resolution.com>)
List pgsql-performance
* Anthony Presley (anthony@resolution.com) wrote:
> I was really hoping that with hardware RAID that something would be faster
> (loading times, queries, etc...).  What am I doing wrong?

ext3 and ext4 do NOT perform identically out of the box..  You might be
running into the write barriers problem here with ext4 forcing the RAID
controllers to push commits all the way to the hard drive before
returning (thus making the BBWC next to useless).

You might try w/ ext3 on the new system instead.

Also, the p800's are definitely better than the p400's, but I don't know
that it's the controller that's really the issue here..

    Thanks,

        Stephen

Attachment

pgsql-performance by date:

Previous
From: Hany ABOU-GHOURY
Date:
Subject: Re: Databases optimization
Next
From: Stephen Frost
Date:
Subject: Re: Postgres for a "data warehouse", 5-10 TB