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
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 |