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 98B039FB1CA for ; Wed, 9 Aug 2006 02:45:17 -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 06589-08 for ; Wed, 9 Aug 2006 02:45:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by postgresql.org (Postfix) with ESMTP id B784A9FA7BA for ; Wed, 9 Aug 2006 02:45:08 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id n28so36597nfc for ; Tue, 08 Aug 2006 22:45:07 -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=BZZ4CmbSpmEN05Fe5FkdHuoQ9Q1XNuB7CPOf3p44v7xJmuGZnPaFTlrBH5LfobqbE8iqeEYsuuo0iSvaoBK0/C34hqsEoSu8+RolGrhj/Q0j3GLE3KQwjWQlBNxvwOcWLpEwmBWlN+hka/pfOcnmPz4g4P0V5p40s7tFaudK4Sc= Received: by 10.78.107.8 with SMTP id f8mr152855huc; Tue, 08 Aug 2006 22:45:07 -0700 (PDT) Received: by 10.78.33.3 with HTTP; Tue, 8 Aug 2006 22:45:07 -0700 (PDT) Message-ID: <721b21dc0608082245u6ee62e7dg522ff18e4d72683@mail.gmail.com> Date: Tue, 8 Aug 2006 22:45:07 -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: <3E37B936B592014B978C4415F90D662D03FFEF6E@MI8NYCMAIL06.Mi8.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_28456_33520875.1155102307237" References: <3E37B936B592014B978C4415F90D662D03FFEF6E@MI8NYCMAIL06.Mi8.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.388 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/128 X-Sequence-Number: 20313 ------=_Part_28456_33520875.1155102307237 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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_28456_33520875.1155102307237 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_28456_33520875.1155102307237--