X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4A1F09FB214 for ; Tue, 8 Aug 2006 10:57:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 76518-09 for ; Tue, 8 Aug 2006 10:57:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.230]) by postgresql.org (Postfix) with ESMTP id 06C959FB209 for ; Tue, 8 Aug 2006 10:57:11 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id h31so570965wxd for ; Tue, 08 Aug 2006 06:57:10 -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=rpVi1juAmHH61tPMAmmmkXZmGY7YqMBSzMESH2uU1NWUs6/iO5j0kjtT9audb/kC4YLry++M5dTfh4Ee77TLEHOgRHCGd0eP1C6VjudB+WtpqIt8ByoNczTZs1dUGhNhKzPerpOH0XPtu4RGuJxh0BIjitQhfUGQtR0T4iLl+5U= Received: by 10.78.117.10 with SMTP id p10mr2778508huc; Tue, 08 Aug 2006 06:57:10 -0700 (PDT) Received: by 10.78.33.3 with HTTP; Tue, 8 Aug 2006 06:57:10 -0700 (PDT) Message-ID: <721b21dc0608080657u2be4a27cwea62207a9265117d@mail.gmail.com> Date: Tue, 8 Aug 2006 06:57:10 -0700 From: "Steve Poe" To: "Alex Turner" Subject: Re: Postgresql Performance on an HP DL385 and Cc: "Luke Lonergan" , pgsql-performance@postgresql.org In-Reply-To: <33c6269f0608072340r7c2a6849i48eae3ea393e00d4@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11069_13031820.1155045430140" References: <1155010416.17773.1.camel@amd64-gentoo-laptop> <33c6269f0608072340r7c2a6849i48eae3ea393e00d4@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.696 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/101 X-Sequence-Number: 20286 ------=_Part_11069_13031820.1155045430140 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Alex, Maybe I mis-stated, this is a 6-disk array. Steve On 8/7/06, Alex Turner wrote: > > 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_11069_13031820.1155045430140 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Alex,

Maybe I mis-stated, this is a 6-disk array.

Steve

On 8/7/06, Alex Turner <armtuk@gmail.com > wrote:
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_11069_13031820.1155045430140--