Re: Easy read-heavy benchmark kicking around?

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Spiegelberg, Greg" <gspiegelberg(at)cranel(dot)com>
Cc: "Pg Performance list" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Easy read-heavy benchmark kicking around?
Date: 2006-11-09 17:28:50
Message-ID: b42b73150611090928r4072926fkae382c21a0bc0ce9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 11/8/06, Spiegelberg, Greg <gspiegelberg(at)cranel(dot)com> wrote:
> Merlin,
>
> I'm kinda shocked you had such a bad exp. with the AMS200. We have a
> unit here hooked up to a 4-node Linux cluster with 4 databases banging
> on it and we get good, consistent perfomance out of it. All 4 nodes can
> throw 25 to 75 MB/s simultaneously without a hiccup.
>
> I'm curious, what was your AMS, server and SAN config?

we had quad opteron 870 in a sun v40z. two trays of 400g sata drives
and the 4 15k fc drives they make you buy. o/s was originally gentoo
and emulex but we switched to redhat as4/qlogic to get support from
them.

the highest performance we ever got was around 120mb/sec writing to
the 4 fc drives in raid 10. however, the sata's could not even do 100
and for some reason when we added a second raid group the performance
dropped 40% for a reason that their performance group could not
explain. compounding the problem was that our assigned tech did not
know linux and there was a one week turnaround to get support emails
answered. Their sales and support staff were snotty and completely
unhelpful. Also we had to do a complex migration process which
involved physically moving the unit to multiple racks for data
transfer which we were going to have to coordinate with hitachi
support because they do not allow you to rack/unrack your own unit.

ultimately, we returned the unit and bought a adtx san. for less than
half the price of the hitachi, we got a dual 4gb controller mixed
sata/sas that supports 750g sata drives. It also has sas ports in the
back for direct attachment to sas hba. in an active/active
configuration, the unit can sustain 500mb/sec, and has 50% more
storage in 1/3 the rack space.

melrin

Browse pgsql-performance by date

  From Date Subject
Next Message imad 2006-11-09 17:55:41 Re: Keeping processes open for re-use
Previous Message Csaba Nagy 2006-11-09 12:56:04 Re: Keeping processes open for re-use