X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 1A2C6D723A
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun,  4 Sep 2005 11:38:30 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 04780-03
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun,  4 Sep 2005 14:38:27 +0000 (GMT)
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by svr1.postgresql.org (Postfix) with SMTP id EB261D70BA
	for <pgsql-performance@postgresql.org>;
	Sun,  4 Sep 2005 11:38:25 -0300 (ADT)
Received: (qmail invoked by alias); 04 Sep 2005 14:38:29 -0000
Received: from dyndsl-085-016-001-021.ewe-ip-backbone.de (EHLO
	Dellerium.party.net) [85.16.1.21]
	by mail.gmx.net (mp021) with SMTP; 04 Sep 2005 16:38:29 +0200
X-Authenticated: #1246422
Subject: Re: Poor performance on HP Package Cluster
From: Ernst Einstein <Crusader@gmx.ch>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: Dan Harris <fbsd@drivefaster.net>,
	pgsql-performance@postgresql.org
In-Reply-To: <BF3D291A.ED00%llonergan@greenplum.com>
References: <BF3D291A.ED00%llonergan@greenplum.com>
Content-Type: multipart/alternative; boundary="=-HDg5Hv9ESi1ADrEMAlEc"
Date: Sun, 04 Sep 2005 17:47:55 +0200
Message-Id: <1125848875.6873.10.camel@Dellerium.party.net>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.2 
X-Y-GMX-Trusted: 0
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.087 required=5 tests=[HTML_40_50=0.086,
	HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200509/68
X-Sequence-Number: 14376


--=-HDg5Hv9ESi1ADrEMAlEc
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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
> 

-- 
Ernst Einstein <Crusader@gmx.ch>

--=-HDg5Hv9ESi1ADrEMAlEc
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.2.3">
</HEAD>
<BODY>
Hi !<BR>
<BR>
Sorry, for my late answer. I was unavailable for a few days...<BR>
<BR>
Yes, I'm using the build-in HP Smart Array Controller. Both, the internal disks, and the external storrage are using the controller.<BR>
<BR>
Can you send me your test results? I'm interested in it.<BR>
<BR>
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. <BR>
<BR>
Greetings Ernst<BR>
<BR>
<BR>
Am Donnerstag, den 01.09.2005, 21:54 -0700 schrieb Luke Lonergan:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Dan,</FONT>

<FONT COLOR="#000000">On 9/1/05 4:02 PM, &quot;Dan Harris&quot; &lt;<A HREF="mailto:fbsd@drivefaster.net">fbsd@drivefaster.net</A>&gt; wrote:</FONT>

<FONT COLOR="#000000">&gt; Do you have any sources for that information?  I am running dual</FONT>
<FONT COLOR="#000000">&gt; SmartArray 6402's in my DL585 and haven't noticed anything poor about</FONT>
<FONT COLOR="#000000">&gt; their performance.</FONT>

<FONT COLOR="#000000">I've previously posted comprehensive results using the 5i and 6xxx series</FONT>
<FONT COLOR="#000000">smart arrays using software RAID, HW RAID on 3 different kernels, alongside</FONT>
<FONT COLOR="#000000">LSI and Adaptec SCSI controllers, and an Adaptec 24xx HW RAID adapter.</FONT>
<FONT COLOR="#000000">Results with bonnie++ and simple sequential read/write with dd.</FONT>

<FONT COLOR="#000000">I'll post them again here for reference in the next message.  Yes, the</FONT>
<FONT COLOR="#000000">performance of the SmartArray controllers under Linux was abysmal, even when</FONT>
<FONT COLOR="#000000">run by the labs at HP.</FONT>

<FONT COLOR="#000000">- Luke</FONT>



<FONT COLOR="#000000">---------------------------(end of broadcast)---------------------------</FONT>
<FONT COLOR="#000000">TIP 1: if posting/reading through Usenet, please send an appropriate</FONT>
<FONT COLOR="#000000">       subscribe-nomail command to <A HREF="mailto:majordomo@postgresql.org">majordomo@postgresql.org</A> so that your</FONT>
<FONT COLOR="#000000">       message can get through to the mailing list cleanly</FONT>

</PRE>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
Ernst Einstein &lt;<A HREF="mailto:Crusader@gmx.ch">Crusader@gmx.ch</A>&gt;
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

--=-HDg5Hv9ESi1ADrEMAlEc--