pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 15:30:20 +0100
Message-ID: <493FD27C.70704@sime.com> (raw)
In-Reply-To: <dcc563d10812100617p9955455kabbc0e9e6327574e@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>
	<493F739C.9080800@sime.com>
	<dcc563d10812100617p9955455kabbc0e9e6327574e@mail.gmail.com>

Scott Marlowe schrieb:
> On Wed, Dec 10, 2008 at 12:45 AM, Mario Weilguni <mweilguni@sime.com> wrote:
>   
>> 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?
>>     
>
> What tests have you or the customer done to confirm that performance
> is very very good?  A lot of times the system is not as fast as the
> customer thinks, it's just faster than it was before and they're
> happy.  Also, there could be problems in the driver or firmware on
> your P400 versus the customer one.  I'd look for those differences as
> well.  I doubt SATA versus SAS is the problem, but who knows...
>
>   
Well, I cannot take the box offline to make usefull tests like tiobench 
or bonnie, but even with the current service running I get from a simple 
dd between 270 and 340 MB/sec sustained read over 30% of the disk.

It also performed extremly good when I put the box into production, 
pg_bench values were impressing, but I do not have them at hand.

However, currently we are seriously considering dropping RAID5 in favor 
of RAID10, we will test this week if this performs better.

Regards
Mario



view thread (33+ messages)  latest in thread

Message-ID: <493FD27C.70704@sime.com>
Permalink:  ../493FD27C.70704@sime.com/
Also on:    postgresql.org/message-id/493FD27C.70704@sime.com

 · 

reply

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: <493FD27C.70704@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