Re: Easy read-heavy benchmark kicking around?

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Markus Schaber" <schabi(at)logix-tt(dot)com>
Cc: "Brian Hurt" <bhurt(at)janestcapital(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Easy read-heavy benchmark kicking around?
Date: 2006-11-08 19:32:50
Message-ID: C17770E2.60CC%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Similar experiences with HP and their SmartArray 5i controller on Linux.
The answer was: "this controller has won awards for performance! It can't be
slow!", so we made them test it in their own labs an prove just how awfully
slow it was. In the case of the 5i, it became apparent that HP had no
internal expertise on Linux and their controllers, the driver was built by a
third party that they didn't support and their performance people didn't
deal with the 5i at all.

In the end, all manner of benchmarks after you've purchased aren't a good
substitute for the up front question: do you have documentation of the
performance of your RAID controller on [Linux, Solaris, ...]?

I would like everyone who purchases IBM, Dell, HP or Sun to demand that
documentation - then perhaps we'd see higher quality drivers and hardware
result.

- Luke

On 11/8/06 8:34 AM, "Merlin Moncure" <mmoncure(at)gmail(dot)com> wrote:

> On 11/8/06, Markus Schaber <schabi(at)logix-tt(dot)com> wrote:
>> Hi, Brian,
>>
>> Brian Hurt wrote:
>>
>>> So the question is: is there an easy to install and run, read-heavy
>>> benchmark out there that I can wave at them to get them to fix the
>>> problem?
>>
>> For sequential read performance, use dd. Most variants of dd I've seen
>> output some timing information, and if not, do a "time dd
>> if=/your/device of=/dev/null bs=1M" on the partition.
>
> we had a similar problem with a hitachi san, the ams200. Their
> performance group refused to admit the fact that 50mb/sec dd test was
> a valid performance benchmark and needed to be addressed. Yes, that
> was a HITACHI SAN, the AMS200, which hitachi's performance group
> claimed was 'acceptable performance'. This was the advice we got
> after swapping out all the hardware and buying an entitlement to
> redhat enterprise which we had to do to get them to talk to us.
>
> oh, the unit also lost a controller after about a week of
> operation...the unit being a HITACHI SAN, the AMS200.
>
> any questions?
>
> merlin
>
> p.s. we have had good experiences with the adtx.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Hilary Forbes 2006-11-09 12:35:00 Keeping processes open for re-use
Previous Message Ron Mayer 2006-11-08 17:14:49 Re: Which OS provides the _fastest_ PostgreSQL performance?