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 B5D5B9FB21F for ; Mon, 7 Aug 2006 23:28:57 -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 60155-08 for ; Tue, 8 Aug 2006 02:28:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id D7F709F9B55 for ; Mon, 7 Aug 2006 23:28:48 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so271586ugc for ; Mon, 07 Aug 2006 19:28:46 -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=cHjreBk4S+uBmca7IeGaiEVVkPoW3qdahGf7Bn43L32tSakV2k5wwRt/bxY+mSI0Hwx3RXLH14tFheblB3KDsWkHLz/RaWSSJmxBwLP7WhDOMHYR8oyasGnQtbDDbcCkV0uJfA3wLBwEUPdb4o2oMqRgSjuYEaDEHW2mYBi95sU= Received: by 10.78.147.3 with SMTP id u3mr2577253hud; Mon, 07 Aug 2006 19:28:46 -0700 (PDT) Received: by 10.78.33.3 with HTTP; Mon, 7 Aug 2006 19:28:46 -0700 (PDT) Message-ID: <721b21dc0608071928ve091390p1cf8226c62efd4@mail.gmail.com> Date: Mon, 7 Aug 2006 19:28:46 -0700 From: "Steve Poe" To: "Joshua D. Drake" Subject: Re: Postgresql Performance on an HP DL385 and Cc: "Luke Lonergan" , pgsql-performance@postgresql.org In-Reply-To: <44D7F49C.9000601@commandprompt.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_209972_32723395.1155004126090" References: <44D7F49C.9000601@commandprompt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.574 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/91 X-Sequence-Number: 20276 ------=_Part_209972_32723395.1155004126090 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline There is 64MB on the 6i and 192MB on the 642 controller. I wish the controllers had a "wrieback" enable option like the LSI MegaRAID adapters have. I have tried splitting the cache accelerator 25/75 75/25 0/100 100/0 but the results really did not improve. Steve On 8/7/06, Joshua D. Drake wrote: > > > >> 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. > > I have heard that the 6i was actually decent but to avoid the 5i. > > Joshua D. Drake > > > >> > >> 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 > > > > > -- > > === The PostgreSQL Company: Command Prompt, Inc. === > Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 > Providing the most comprehensive PostgreSQL solutions since 1997 > http://www.commandprompt.com/ > > > ------=_Part_209972_32723395.1155004126090 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline There is 64MB on the 6i and 192MB on the 642 controller. I wish the controllers had a "wrieback" enable option like the LSI MegaRAID adapters have. I have tried splitting the cache accelerator 25/75 75/25 0/100 100/0 but the results really did not improve.

Steve

On 8/7/06, Joshua D. Drake <jd@commandprompt.com> wrote:

>> 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.

I have heard that the 6i was actually decent but to avoid the 5i.

Joshua D. Drake


>>
>> 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
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



------=_Part_209972_32723395.1155004126090--