From: Mario Weilguni <mweilguni@sime.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Alan Hodgson <ahodgson@simkin.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Experience with HP Smart Array P400 and SATA drives?
Date: Wed, 10 Dec 2008 08:45:32 +0100
Message-ID: <493F739C.9080800@sime.com> (raw)
In-Reply-To: <dcc563d10812090730h2ae6658cj5fdc2554600efd40@mail.gmail.com>
References: <4934FE60.30702@sime.com>
<49395B57.EE98.0025.0@wicourts.gov>
<200812051530.01258@hal.medialogik.com>
<493E61E1.1020303@sime.com>
<dcc563d10812090730h2ae6658cj5fdc2554600efd40@mail.gmail.com>
Scott Marlowe schrieb:
> On Tue, Dec 9, 2008 at 5:17 AM, Mario Weilguni <mweilguni@sime.com> wrote:
>
>> Alan Hodgson schrieb:
>>
>>>>>>> Mario Weilguni <mweilguni@sime.com> wrote:
>>>>>>>
>>>>>>>
>>>>> strange values. An individual drive is capable of delivering 91
>>>>> MB/sec
>>>>> sequential read performance, and we get values ~102MB/sec out of a
>>>>> 8-drive RAID5, seems to be ridiculous slow.
>>>>>
>>> What command are you using to test the reads?
>>>
>>> Some recommendations to try:
>>>
>>> 1) /sbin/blockdev --setra 2048 device (where device is the partition or
>>> LVM volume)
>>>
>>> 2) Use XFS, and make sure your stripe settings match the RAID.
>>>
>>> Having said that, 102MB/sec sounds really low for any modern controller
>>> with 8 drives, regardless of tuning or filesystem choice.
>>>
>>>
>>>
>> First, thanks alot for this and all the other answers.
>>
>> I measured the raw device performance:
>> dd if=/dev/cciss/c0d0 bs=64k count=100000 of=/dev/null
>>
>> I get poor performance when all 8 drives are configured as one, large
>> RAID-5, and slightly poorer performance when configured as JBOD. In
>> production, we use XFS as FS, but I doubt this has anything to do with FS
>> tuning.
>>
>
> Yeah, having just trawled the pgsql-performance archives, there are
> plenty of instances of people having terrible performance from HP
> smart array controllers before the P800. Is it possible for you to
> trade up to a better RAID controller? Whichever salesman sold you the
> P400 should take one for the team and make this right for you.
>
>
A customer of us uses the P400 on a different machine, 8 SAS drives
(Raid 5 as well), and the performance is very, very good. So we thought
it's a good choice. Maybe the SATA drives are the root of this problem?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mweilguni@sime.com, scott.marlowe@gmail.com, ahodgson@simkin.ca
Subject: Re: Experience with HP Smart Array P400 and SATA drives?
In-Reply-To: <493F739C.9080800@sime.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox