X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 077A19FB2E0 for ; Wed, 9 Aug 2006 03:47:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 87093-06 for ; Wed, 9 Aug 2006 06:47:51 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id 60CB69FB2D5 for ; Wed, 9 Aug 2006 03:47:50 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id n28so53205nfc for ; Tue, 08 Aug 2006 23:47:44 -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=ImMWib9u4X8k0XDYTtGWPZL/bId2cw8YtMHy2aHIAZMm7dymLW+VgQxHFu79w1ZbBePfJoigWfM/USp0MQ+v5UJa3+KpwM5EENYdihEOwwKTIDNRBuYHDxUl1wp9iduT/q6ppXNsEZQCL82I786EzXN1TQW5JAXQmXvS8w3yvqc= Received: by 10.78.147.19 with SMTP id u19mr184705hud; Tue, 08 Aug 2006 23:47:44 -0700 (PDT) Received: by 10.78.33.3 with HTTP; Tue, 8 Aug 2006 23:47:44 -0700 (PDT) Message-ID: <721b21dc0608082347j1e010187lde10a809980e12ce@mail.gmail.com> Date: Tue, 8 Aug 2006 23:47:44 -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: <3E37B936B592014B978C4415F90D662D03FFEF75@MI8NYCMAIL06.Mi8.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_28901_15841006.1155106064473" References: <3E37B936B592014B978C4415F90D662D03FFEF75@MI8NYCMAIL06.Mi8.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.334 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_50_60, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/132 X-Sequence-Number: 20317 ------=_Part_28901_15841006.1155106064473 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Luke, I will do that. If it is the general impression that this server should perform well with Postgresql, Are the RAID cards, the 6i and 642 sufficient to your knowledge? I am wondering if it is the disc array itself. Steve On 8/8/06, Luke Lonergan wrote: > > Steve, > > At the end of the day it seems that you've got a support issue with the > SmartArray RAID adapter from HP. > > Last I tried that I found that they don't write the cciss driver, don't > test it for performance on Linux and don't make any claims about it's > performance on Linux. > > That said - can you contact them through HP tech support and report back > to this list what you find out? > > - Luke > > -----Original Message----- > > From: Steve Poe [mailto:steve.poe@gmail.com] > > Sent: Tuesday, August 08, 2006 11:33 PM > > To: Luke Lonergan > > Cc: Alex Turner; pgsql-performance@postgresql.org > > Subject: Re: [PERFORM] Postgresql Performance on an HP DL385 and > > > > Luke, > > > > I check dmesg one more time and I found this regarding the > > cciss driver: > > > > Filesystem "cciss/c1d0p1": Disabling barriers, not supported > > by the underlying device. > > > > Don't know if it means anything, but thought I'd mention it. > > > > Steve > > > > > > On 8/8/06, Steve Poe wrote: > > > > Luke, > > > > I thought so. In my test, I tried to be fair/equal > > since my Sun box has two 4-disc arrays each on their own > > channel. So, I just used one of them which should be a little > > slower than the 6-disc with 192MB cache. > > > > Incidently, the two internal SCSI drives, which are on > > the 6i adapter, generated a TPS of 18. > > > > I thought this server would impressive from notes I've > > read in the group. This is why I thought I might be doing > > something wrong. I stumped which way to take this. There is > > no obvious fault but something isn't right. > > > > > > Steve > > > > > > > > On 8/8/06, Luke Lonergan < LLonergan@greenplum.com > > > wrote: > > > > Steve, > > > > > Sun box with 4-disc array (4GB RAM. 4 167GB > > 10K SCSI RAID10 > > > LSI MegaRAID 128MB). This is after 8 runs. > > > > > > > > dbserver-dual-opteron-centos,08/08/06,Tuesday,20,us,12,2,5 > > > > > dbserver-dual-opteron-centos,08/08/06,Tuesday,20,sy,59,50,53 > > > > > dbserver-dual-opteron-centos,08/08/06,Tuesday,20,wa,1,0,0 > > > > > dbserver-dual-opteron-centos,08/08/06,Tuesday,20,id,45,26,38 > > > > > > Average TPS is 75 > > > > > > HP box with 8GB RAM. six disc array RAID10 on > > SmartArray 642 > > > with 192MB RAM. After 8 runs, I see: > > > > > > intown-vetstar-amd64,08/09/06,Tuesday,23,us,31,0,3 > > > intown-vetstar-amd64,08/09/06,Tuesday,23,sy,16,0,1 > > > intown-vetstar-amd64,08/09/06,Tuesday,23,wa,99,6,50 > > > intown-vetstar-amd64,08/09/06,Tuesday,23,id,78,0,42 > > > > > > Average TPS is 31. > > > > Note that the I/O wait (wa) on the HP box high, > > low and average are all > > *much* higher than on the Sun box. The average > > I/O wait was 50% of one > > CPU, which is huge. By comparison there was > > virtually no I/O wait on > > the Sun machine. > > > > This is indicating that your HP machine is > > indeed I/O bound and > > furthermore is tying up a PG process waiting > > for the disk to return. > > > > - Luke > > > > > > > > > > > > > > ------=_Part_28901_15841006.1155106064473 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Luke,

I will do that. If it is the general impression that this server should perform well with Postgresql, Are the RAID cards, the 6i and 642 sufficient to your knowledge? I am wondering if it is the disc array itself.

Steve

On 8/8/06, Luke Lonergan <LLonergan@greenplum.com> wrote:
Steve,

At the end of the day it seems that you've got a support issue with the
SmartArray RAID adapter from HP.

Last I tried that I found that they don't write the cciss driver, don't
test it for performance on Linux and don't make any claims about it's
performance on Linux.

That said - can you contact them through HP tech support and report back
to this list what you find out?

- Luke
> -----Original Message-----
> From: Steve Poe [mailto: steve.poe@gmail.com]
> Sent: Tuesday, August 08, 2006 11:33 PM
> To: Luke Lonergan
> Cc: Alex Turner; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Postgresql Performance on an HP DL385 and
>
> Luke,
>
> I check dmesg one more time and I found this regarding the
> cciss driver:
>
> Filesystem "cciss/c1d0p1": Disabling barriers, not supported
> by the underlying device.
>
> Don't know if it means anything, but thought I'd mention it.
>
> Steve
>
>
> On 8/8/06, Steve Poe <steve.poe@gmail.com > wrote:
>
>       Luke,
>
>       I thought so. In my test, I tried to be fair/equal
> since my Sun box has two 4-disc arrays each on their own
> channel. So, I just used one of them which should be a little
> slower than the 6-disc with 192MB cache.
>
>       Incidently, the two internal SCSI drives, which are on
> the 6i adapter, generated a TPS of 18.
>
>       I thought this server would impressive from notes I've
> read in the group. This is why I thought I might be doing
> something wrong. I stumped which way to take this. There is
> no obvious fault but something isn't right.
>
>
>       Steve
>
>
>
>       On 8/8/06, Luke Lonergan < LLonergan@greenplum.com
> <mailto:LLonergan@greenplum.com > > wrote:
>
>               Steve,
>
>               > Sun box with 4-disc array (4GB RAM. 4 167GB
> 10K SCSI RAID10
>               > LSI MegaRAID 128MB). This is after 8 runs.
>               >
>               >
> dbserver-dual-opteron-centos,08/08/06,Tuesday,20,us,12,2,5
>               >
> dbserver-dual-opteron-centos,08/08/06,Tuesday,20,sy,59,50,53
>               >
> dbserver-dual-opteron-centos,08/08/06,Tuesday,20,wa,1,0,0
>               >
> dbserver-dual-opteron-centos,08/08/06,Tuesday,20,id,45,26,38
>               >
>               > Average TPS is 75
>               >
>               > HP box with 8GB RAM. six disc array RAID10 on
> SmartArray 642
>               > with 192MB RAM. After 8 runs, I see:
>               >
>               > intown-vetstar-amd64,08/09/06,Tuesday,23,us,31,0,3
>               > intown-vetstar-amd64,08/09/06,Tuesday,23,sy,16,0,1
>               > intown-vetstar-amd64,08/09/06,Tuesday,23,wa,99,6,50
>               > intown-vetstar-amd64,08/09/06,Tuesday,23,id,78,0,42
>               >
>               > Average TPS is 31.
>
>               Note that the I/O wait (wa) on the HP box high,
> low and average are all
>               *much* higher than on the Sun box.  The average
> I/O wait was 50% of one
>               CPU, which is huge.  By comparison there was
> virtually no I/O wait on
>               the Sun machine.
>
>               This is indicating that your HP machine is
> indeed I/O bound and
>               furthermore is tying up a PG process waiting
> for the disk to return.
>
>               - Luke
>
>
>
>
>
>


------=_Part_28901_15841006.1155106064473--