pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Luke Lonergan <llonergan@greenplum.com>
To: Ernst Einstein <Crusader@gmx.ch>
Cc: Dan Harris <fbsd@drivefaster.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Poor performance on HP Package Cluster
Date: Sun, 04 Sep 2005 10:19:53 -0700
Message-ID: <BF407AC9.EE90%llonergan@greenplum.com> (raw)
In-Reply-To: <1125848875.6873.10.camel@Dellerium.party.net>

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@gmx.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@drivefaster.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@postgresql.org so that your
>>        message can get through to the mailing list cleanly

view thread (7+ messages)

Message-ID: <BF407AC9.EE90%llonergan@greenplum.com>
Permalink:  ../BF407AC9.EE90%25llonergan@greenplum.com/
Also on:    postgresql.org/message-id/BF407AC9.EE90%llonergan@greenplum.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: llonergan@greenplum.com, Crusader@gmx.ch, fbsd@drivefaster.net
  Subject: Re: Poor performance on HP Package Cluster
  In-Reply-To: <BF407AC9.EE90%llonergan@greenplum.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