Message-ID: <4E6D7CF5.8000501@archidevsys.co.nz>
Date: Mon, 12 Sep 2011 15:31:01 +1200
From: Gavin Flower <GavinFlower@archidevsys.co.nz>
Organization: ArchiDevSys
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
To: mark <dvlhntr@gmail.com>
CC: "'Anthony Presley'" <anthony@resolution.com>,
	pgsql-performance@postgresql.org
Subject: Re: RAID Controller (HP P400) beat by SW-RAID?
References: 
 <CAO2AxyoGvmRYtq=1=weOU_CCnAxK8FboBa8GWS6XZ923CXCCgA@mail.gmail.com>
	<007601cc70f9$7d150940$773f1bc0$@com>
In-Reply-To: <007601cc70f9$7d150940$773f1bc0$@com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

On 12/09/11 15:10, mark wrote:
>
>> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Anthony Presley
>> Sent: Sunday, September 11, 2011 4:45 PM
>> To: pgsql-performance@postgresql.org
>> Subject: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?
>> 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 drives configured as RAID 1+0 (seems with this controller, I cannot
> do JBOD).  I've spent a few hours going back and forth benchmarking the new
> systems, and have set up the DWC, and the accelerator cache using hpacucli.
>   I've tried accelerator caches of 25/75, 50/50, and 75/25.
>
> I would start of by recommending a more current version of 9.0...like 9.0.4
> since you are building a new box. The rumor mill says 9.0.5 and 9.1.0 might
> be out soon (days?). but that is just rumor mill. Don't bank on it.
>
>
> What kernel are you on ?
>
> Long time HP user here, for better and worse... so here are a few other
> little things I recommend.
>
> Check the bios power management. Make sure it is set where you want it.
> (IIRC the G5s have this, I know G6s and G7s do). This can help with nasty
> latency problems if the box has been idle for a while then needs to start
> doing work.
>
> The p400i is not a great card, compared to more modern one, but you should
> be able to beat the old setup with what you have. Faster clocked cpu's more
> spindles, faster RPM spindles.
>
> Assuming the battery is working, with XFS or ext4 you can use nobarrier
> mount option and you should see some improvement.
>
>
> Make sure the raid card's firmware is current. I can't stress this enough.
> HP fixed a nasty bug with Raid 1+0 a few months ago where you could eat your
> data... They also seem to be fixing a lot of other bugs along the way as
> well. So do yourself a big favor and make sure that firmware is current. It
> might just head off headache down the road.
>
> Also make sure you have a 8.10.? (IIRC the version number right) or better
> version of hpacucli... there have been some fixes to that utility as well.
> IIRC most of the fixes in this have been around recognizing newere cards
> (812s and 410s) but some interface bugs have been fixed as well.   You may
> need new packages for HP health. (I don't recall the official name, but new
> versions if hpacucli might not play well with old versions of hp health.
>
> Its HP so they have a new version about every month for firmware and their
> cli utility... that’s HP for us.
>
> Anyways that is my fast input.
>
> Best of luck,
>
>
> -Mark
>
>
pg 9.1.0 has already been released!

I have had it installed and running for just under 24 hours...

though http://www.postgresql.org/ is still not showing it,
see:
http://www.postgresql.org/ftp/source/
and
http://jdbc.postgresql.org/download.html


Cheers,
Gavin