From: | "Steve Poe" <steve(dot)poe(at)gmail(dot)com> |
---|---|
To: | "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com> |
Cc: | "Luke Lonergan" <llonergan(at)greenplum(dot)com>, "Michael Stone" <mstone+postgres(at)mathom(dot)us>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Postgresql Performance on an HP DL385 and |
Date: | 2006-08-10 15:47:05 |
Message-ID: | 721b21dc0608100847i166be1e6x4903357e6d35f82f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Scott,
I *could* rip out the LSI MegaRAID 2X from my Sun box. This belongs to me
for testing. but I don't know if it will fit in the DL385. Do they have
full-heigth/length slots? I've not worked on this type of box before. I was
thinking this is the next step. In the meantime, I've discovered their no
email support for them so I am hoping find a support contact through the
sales rep that this box was purchased from.
Steve
On 8/10/06, Scott Marlowe <smarlowe(at)g2switchworks(dot)com> wrote:
>
> On Thu, 2006-08-10 at 10:15, Luke Lonergan wrote:
> > Mike,
> >
> > On 8/10/06 4:09 AM, "Michael Stone" <mstone+postgres(at)mathom(dot)us> wrote:
> >
> > > On Wed, Aug 09, 2006 at 08:29:13PM -0700, Steve Poe wrote:
> > >> I tried as you suggested and my performance dropped by 50%. I went
> from
> > >> a 32 TPS to 16. Oh well.
> > >
> > > If you put data & xlog on the same array, put them on seperate
> > > partitions, probably formatted differently (ext2 on xlog).
> >
> > If he's doing the same thing on both systems (Sun and HP) and the HP
> > performance is dramatically worse despite using more disks and having
> faster
> > CPUs and more RAM, ISTM the problem isn't the configuration.
> >
> > Add to this the fact that the Sun machine is CPU bound while the HP is
> I/O
> > wait bound and I think the problem is the disk hardware or the driver
> > therein.
>
> I agree. The problem here looks to be the RAID controller.
>
> Steve, got access to a different RAID controller to test with?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-08-10 15:50:17 | Re: 3-table query optimization |
Previous Message | Scott Marlowe | 2006-08-10 15:35:10 | Re: Postgresql Performance on an HP DL385 and |