X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3C8DB9FB2EF for ; Thu, 10 Aug 2006 12:47:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 93451-06 for ; Thu, 10 Aug 2006 15:47:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 7C4909FB25E for ; Thu, 10 Aug 2006 12:47:18 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id n28so651940nfc for ; Thu, 10 Aug 2006 08:47:06 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=lcxs9Gybprgx66NQk99JAeFGEuXlKMsp9mSNoti5S+SwxDv8b7Hq1xqSUUNWHJvowtW+apwVIrJXK8BNhmDlpwTiRXijIN1GhiMIOH7keCAuNNN+D3WKXgMAO6/l5WRDfxC7Ugr8t9davG3fX0a2zMgKeWdW4rTQQfa+2xFwR88= Received: by 10.78.157.8 with SMTP id f8mr1431274hue; Thu, 10 Aug 2006 08:47:06 -0700 (PDT) Received: by 10.78.33.3 with HTTP; Thu, 10 Aug 2006 08:47:05 -0700 (PDT) Message-ID: <721b21dc0608100847i166be1e6x4903357e6d35f82f@mail.gmail.com> Date: Thu, 10 Aug 2006 08:47:05 -0700 From: "Steve Poe" To: "Scott Marlowe" Subject: Re: Postgresql Performance on an HP DL385 and Cc: "Luke Lonergan" , "Michael Stone" , pgsql-performance@postgresql.org In-Reply-To: <1155224109.20252.144.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_62928_17604620.1155224825858" References: <1155224109.20252.144.camel@state.g2switchworks.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/188 X-Sequence-Number: 20373 ------=_Part_62928_17604620.1155224825858 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 wrote: > > On Thu, 2006-08-10 at 10:15, Luke Lonergan wrote: > > Mike, > > > > On 8/10/06 4:09 AM, "Michael Stone" 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 > ------=_Part_62928_17604620.1155224825858 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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

------=_Part_62928_17604620.1155224825858--