From: Steve Poe <steve.poe@gmail.com>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql Performance on an HP DL385 and
Date: Mon, 7 Aug 2006 18:46:34 -0700
Message-ID: <721b21dc0608071846q2128d478tab94b76dbc549a26@mail.gmail.com> (raw)
In-Reply-To: <C0FD32A1.2D871%llonergan@greenplum.com>
References: <1154819438.15224.24.camel@amd64-gentoo-laptop>
<C0FD32A1.2D871%llonergan@greenplum.com>
Luke,
I'll do that then post the results. I ran zcav on it (default settlings) on
the disc array formatted XFS and its peak MB/s was around 85-90. I am using
kernel 2.6.17.7. mounting the disc array with noatime, nodiratime.
Thanks for your feedback.
Steve
On 8/7/06, Luke Lonergan <llonergan@greenplum.com> wrote:
>
> Steve,
>
> On 8/5/06 4:10 PM, "Steve Poe" <steve.poe@gmail.com> wrote:
>
> > I am do some consulting for an animal hospital in the Boston, MA area.
> > They wanted a new server to run their database on. The client wants
> > everything from one vendor, they wanted Dell initially, I'd advised
> > against it. I recommended a dual Opteron system from either Sun or HP.
> > They settled on a DL385 8GB of RAM with two disc U320 SCSI and a 6-disc
> > U320 SCSI array. I recommended they add a RAID adapter with at 128MB and
> > battery backup, they added a HP SmartArray 642 to connect to the drive
> > array in addition to the SmartArray 6i which came with the server.
> >
> > Has anyone worked with server before. I've read the SmartArray 6i is a
> > poor performer, I wonder if the SmartArray 642 adapter would have the
> > same fate?
> >
> > The database data is on the drive array(RAID10) and the pg_xlog is on
> > the internal RAID1 on the 6i controller. The results have been poor.
> >
> > My guess is the controllers are garbage.
>
> 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
>
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: steve.poe@gmail.com, llonergan@greenplum.com
Subject: Re: Postgresql Performance on an HP DL385 and
In-Reply-To: <721b21dc0608071846q2128d478tab94b76dbc549a26@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