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 4B8AA9FB281 for ; Tue, 8 Aug 2006 03:40:50 -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 37501-01 for ; Tue, 8 Aug 2006 06:40:42 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id 29E469FB278 for ; Tue, 8 Aug 2006 03:40:40 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id n28so121535nfc for ; Mon, 07 Aug 2006 23:40:39 -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=YrMvWvztCk2V6TPCcx0yabAoQ3o1SGIDtJxyW6hgT+vC7edN30b7QVzoUxunrR3JcUfaudWz7OzLAJJ4VzEDDohJfONPDcDBOJs9w+NLvFoaw0WIFZkv17KPJTn9uQA4EU7beN+4s8dPIhwzkP+j2TNs52Y36KlkNintAE10X8w= Received: by 10.78.142.14 with SMTP id p14mr2627113hud; Mon, 07 Aug 2006 23:40:39 -0700 (PDT) Received: by 10.78.140.12 with HTTP; Mon, 7 Aug 2006 23:40:39 -0700 (PDT) Message-ID: <33c6269f0608072340r7c2a6849i48eae3ea393e00d4@mail.gmail.com> Date: Tue, 8 Aug 2006 02:40:39 -0400 From: "Alex Turner" To: steve.poe@gmail.com Subject: Re: Postgresql Performance on an HP DL385 and Cc: "Luke Lonergan" , pgsql-performance@postgresql.org In-Reply-To: <1155010416.17773.1.camel@amd64-gentoo-laptop> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3279_24692865.1155019239552" References: <1155010416.17773.1.camel@amd64-gentoo-laptop> 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/94 X-Sequence-Number: 20279 ------=_Part_3279_24692865.1155019239552 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline These number are pretty darn good for a four disk RAID 10, pretty close to perfect infact. Nice advert for the 642 - I guess we have a Hardware RAID controller than will read indpendently from mirrors. Alex On 8/8/06, Steve Poe wrote: > > Luke, > > Here are the results of two runs of 16GB file tests on XFS. > > scsi disc array > xfs ,16G,81024,99,153016,24,73422,10,82092,97,243210,17,1043.1 > ,0,16,3172,7,+++++,+++,2957,9,3197,10,+++++,+++,2484,8 > scsi disc array > xfs ,16G,83320,99,155641,25,73662,10,81756,96,243352,18,1029.1 > ,0,16,3119,10,+++++,+++,2789,7,3263,11,+++++,+++,2014,6 > > Thanks. > > Steve > > > > > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ------=_Part_3279_24692865.1155019239552 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline These number are pretty darn good for a four disk RAID 10, pretty close to perfect infact.  Nice advert for the 642 - I guess we have a Hardware RAID controller than will read indpendently from mirrors.

Alex

On 8/8/06, Steve Poe <steve.poe@gmail.com> wrote:
Luke,

Here are the results of two runs of 16GB file tests on XFS.

scsi disc array
xfs ,16G,81024,99,153016,24,73422,10,82092,97,243210,17,1043.1,0,16,3172,7,+++++,+++,2957,9,3197,10,+++++,+++,2484,8
scsi disc array
xfs ,16G,83320,99,155641,25,73662,10,81756,96,243352,18,1029.1,0,16,3119,10,+++++,+++,2789,7,3263,11,+++++,+++,2014,6

Thanks.

Steve



> 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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

------=_Part_3279_24692865.1155019239552--