Re: Postgresql Performance on an HP DL385 and - Mailing list pgsql-performance

From Steve Poe
Subject Re: Postgresql Performance on an HP DL385 and
Date
Msg-id 721b21dc0608100847i166be1e6x4903357e6d35f82f@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql Performance on an HP DL385 and  (Scott Marlowe <smarlowe@g2switchworks.com>)
List 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@g2switchworks.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@mathom.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@postgresql.org so that your
       message can get through to the mailing list cleanly

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Postgresql Performance on an HP DL385 and
Next
From: Alvaro Herrera
Date:
Subject: Re: 3-table query optimization