From: Steve Poe <steve.poe@gmail.com>
To: Luke Lonergan <LLonergan@greenplum.com>
Cc: Alex Turner <armtuk@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql Performance on an HP DL385 and
Date: Tue, 8 Aug 2006 22:45:07 -0700
Message-ID: <721b21dc0608082245u6ee62e7dg522ff18e4d72683@mail.gmail.com> (raw)
In-Reply-To: <3E37B936B592014B978C4415F90D662D03FFEF6E@MI8NYCMAIL06.Mi8.com>
References: <3E37B936B592014B978C4415F90D662D03FFEF6E@MI8NYCMAIL06.Mi8.com>
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
>
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: steve.poe@gmail.com, LLonergan@greenplum.com, armtuk@gmail.com
Subject: Re: Postgresql Performance on an HP DL385 and
In-Reply-To: <721b21dc0608082245u6ee62e7dg522ff18e4d72683@mail.gmail.com>
References: <3E37B936B592014B978C4415F90D662D03FFEF6E@MI8NYCMAIL06.Mi8.com> <721b21dc0608082245u6ee62e7dg522ff18e4d72683@mail.gmail.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