Re: Poor performance on HP Package Cluster

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Ernst Einstein" <Crusader(at)gmx(dot)ch>
Cc: "Dan Harris" <fbsd(at)drivefaster(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor performance on HP Package Cluster
Date: 2005-09-04 17:19:53
Message-ID: BF407AC9.EE90%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Sure ­ I posted the excel spreadsheet to the list right after my message,
but I think it blocks attachments. I¹ll send it to you now privately.

I recommend switching to software RAID 10 or 5 using simple SCSI U320
adapter(s) from LSI or Adaptec, which you can buy from HP if you must.

Cheers,

- Luke

On 9/4/05 8:47 AM, "Ernst Einstein" <Crusader(at)gmx(dot)ch> wrote:

> Hi !
>
> Sorry, for my late answer. I was unavailable for a few days...
>
> Yes, I'm using the build-in HP Smart Array Controller. Both, the internal
> disks, and the external storrage are using the controller.
>
> Can you send me your test results? I'm interested in it.
>
> I've done some testing now. I've imported the data again and tuned the DB like
> I was told in some performance howtos. Now, the database has a good
> performance - until it has to read from the disks.
>
> Greetings Ernst
>
>
> Am Donnerstag, den 01.09.2005, 21:54 -0700 schrieb Luke Lonergan:
>>
>> Dan,
>>
>> On 9/1/05 4:02 PM, "Dan Harris" <fbsd(at)drivefaster(dot)net> wrote:
>>
>>> > Do you have any sources for that information? I am running dual
>>> > SmartArray 6402's in my DL585 and haven't noticed anything poor about
>>> > their performance.
>>
>> I've previously posted comprehensive results using the 5i and 6xxx series
>> smart arrays using software RAID, HW RAID on 3 different kernels, alongside
>> LSI and Adaptec SCSI controllers, and an Adaptec 24xx HW RAID adapter.
>> Results with bonnie++ and simple sequential read/write with dd.
>>
>> I'll post them again here for reference in the next message. Yes, the
>> performance of the SmartArray controllers under Linux was abysmal, even when
>> run by the labs at HP.
>>
>> - Luke
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-09-04 23:01:10 Re: poor VACUUM performance on large tables
Previous Message Ernst Einstein 2005-09-04 15:47:55 Re: Poor performance on HP Package Cluster