Re: Postgresql Performance on an HP DL385 and

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(at)greenplum(dot)com> wrote:
>
> Steve,
>
> On 8/5/06 4:10 PM, "Steve Poe" <steve(dot)poe(at)gmail(dot)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
>