X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E77149FB277 for ; Tue, 8 Aug 2006 12:01:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 82308-06 for ; Tue, 8 Aug 2006 12:01:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.237]) by postgresql.org (Postfix) with ESMTP id DAC7F9FB271 for ; Tue, 8 Aug 2006 12:01:49 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 36so84578wra for ; Tue, 08 Aug 2006 08:01:48 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=lFGeTn67OdUkQJs9YvKDMs0DQDd+PNR/ZcIBSj+eF88qRnuWLIDUHwdXmeAWxzx2dm/ouhm8+mUuFa9AE8QBgyMR4vQf34HE6JoQYCwQuoQTgVqvM90NZjrDGr2lYDo/ZNyPW+nAlsZMTyCuWvZIvpJvJUqxyqoUqOe6/tew6aM= Received: by 10.78.177.3 with SMTP id z3mr2794910hue; Tue, 08 Aug 2006 08:01:48 -0700 (PDT) Received: by 10.78.33.3 with HTTP; Tue, 8 Aug 2006 08:01:47 -0700 (PDT) Message-ID: <721b21dc0608080801l5fb6534ey7094774ff79a323b@mail.gmail.com> Date: Tue, 8 Aug 2006 08:01:47 -0700 From: "Steve Poe" To: "Luke Lonergan" Subject: Re: Postgresql Performance on an HP DL385 and Cc: "Alex Turner" , pgsql-performance@postgresql.org In-Reply-To: <3E37B936B592014B978C4415F90D662D03EA1F78@MI8NYCMAIL06.Mi8.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13373_6078297.1155049307577" References: <3E37B936B592014B978C4415F90D662D03EA1F78@MI8NYCMAIL06.Mi8.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.381 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/103 X-Sequence-Number: 20288 ------=_Part_13373_6078297.1155049307577 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Luke, Thanks for the feedback. I use the same database test that I've run a Sun dual Opteron with 4Gb RAM and (2) four disk arrays in RAID10. The sun box with one disc on an LSI MegaRAID 2-channel adapter outperforms this HP box. I though I was doing something wrong or there is something wrong with the box. Steve On 8/8/06, Luke Lonergan wrote: > > I agree, I think these say you are getting 240MB/s sequential reads and > 1000 seeks per second. > > That's pretty much the best you'd expect. > > - Luke > > Sent from my GoodLink synchronized handheld (www.good.com) > > > -----Original Message----- > From: Alex Turner [mailto:armtuk@gmail.com] > Sent: Tuesday, August 08, 2006 02:40 AM Eastern Standard Time > To: steve.poe@gmail.com > Cc: Luke Lonergan; pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Postgresql Performance on an HP DL385 and > > These number are pretty darn good for a four disk RAID 10, pretty close to > perfect infact. Nice advert for the 642 - I guess we have a Hardware RAID > controller than will read indpendently from mirrors. > > Alex > > On 8/8/06, Steve Poe wrote: > > > > Luke, > > > > Here are the results of two runs of 16GB file tests on XFS. > > > > scsi disc array > > xfs ,16G,81024,99,153016,24,73422,10,82092,97,243210,17,1043.1 > > ,0,16,3172,7,+++++,+++,2957,9,3197,10,+++++,+++,2484,8 > > scsi disc array > > xfs ,16G,83320,99,155641,25,73662,10,81756,96,243352,18,1029.1 > > ,0,16,3119,10,+++++,+++,2789,7,3263,11,+++++,+++,2014,6 > > > > Thanks. > > > > Steve > > > > > > > > > Can you run bonnie++ version 1.03a on the machine and report the > results > > > here? > > > > > > It could be OK if you have the latest Linux driver for cciss, someone > > has > > > reported good results to this list with the latest, bleeding edge > > version of > > > Linux (2.6.17). > > > > > > - Luke > > > > > > > > > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > > TIP 9: In versions below 8.0, the planner will ignore your desire to > > > choose an index scan if your joining column's datatypes do not > > > match > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faq > > > > ------=_Part_13373_6078297.1155049307577 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Luke,

Thanks for the feedback.  I use the same database test that I've run a Sun dual Opteron with 4Gb RAM and (2) four disk arrays in RAID10. The sun box with one disc on an LSI MegaRAID 2-channel adapter outperforms this HP box. I though I was doing something wrong or there is something wrong with the box.

Steve

On 8/8/06, Luke Lonergan <LLonergan@greenplum.com> wrote:
I agree, I think these say you are getting 240MB/s sequential reads and 1000 seeks per second.

That's pretty much the best you'd expect.

- Luke

Sent from my GoodLink synchronized handheld ( www.good.com)


-----Original Message-----
From:   Alex Turner [mailto:armtuk@gmail.com]
Sent:   Tuesday, August 08, 2006 02:40 AM Eastern Standard Time
To:     steve.poe@gmail.com
Cc:     Luke Lonergan; pgsql-performance@postgresql.org
Subject:        Re: [PERFORM] Postgresql Performance on an HP DL385 and

These number are pretty darn good for a four disk RAID 10, pretty close to
perfect infact.  Nice advert for the 642 - I guess we have a Hardware RAID
controller than will read indpendently from mirrors.

Alex

On 8/8/06, Steve Poe <steve.poe@gmail.com> wrote:
>
> Luke,
>
> Here are the results of two runs of 16GB file tests on XFS.
>
> scsi disc array
> xfs ,16G,81024,99,153016,24,73422,10,82092,97,243210,17,1043.1
> ,0,16,3172,7,+++++,+++,2957,9,3197,10,+++++,+++,2484,8
> scsi disc array
> xfs ,16G,83320,99,155641,25,73662,10,81756,96,243352,18, 1029.1
> ,0,16,3119,10,+++++,+++,2789,7,3263,11,+++++,+++,2014,6
>
> Thanks.
>
> Steve
>
>
>
> > Can you run bonnie++ version 1.03a on the machine and report the results
> > here?
> >
> > It could be OK if you have the latest Linux driver for cciss, someone
> has
> > reported good results to this list with the latest, bleeding edge
> version of
> > Linux (2.6.17).
> >
> > - Luke
> >
>
>
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> >        choose an index scan if your joining column's datatypes do not
> >        match
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>


------=_Part_13373_6078297.1155049307577--