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 04D429FB273
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  7 Aug 2006 17:03:12 -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 54056-09 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  7 Aug 2006 17:02:55 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.188])
	by postgresql.org (Postfix) with ESMTP id E74E69FB22F
	for <pgsql-performance@postgresql.org>;
	Mon,  7 Aug 2006 17:02:54 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id n28so1126033nfc
	for <pgsql-performance@postgresql.org>;
	Mon, 07 Aug 2006 13:02:53 -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=sXtdCIXTlOezfof3QiIp4IzaiJw/iH94cFSQ8qnDtXkSbC8hEGuX5jdx1RtVSfhoq/BQc0YoDDtlsixdHfyCjL1mUDOVSTfH1/hgD7jALyBV0024T/1HOg0c/IRpGvovDIu3nVPkpG0oL3eVTv6mzw9NaqG1XYZx3jcjV3b2BfQ=
Received: by 10.78.150.7 with SMTP id x7mr2507721hud;
	Mon, 07 Aug 2006 13:02:52 -0700 (PDT)
Received: by 10.78.140.12 with HTTP; Mon, 7 Aug 2006 13:02:52 -0700 (PDT)
Message-ID: <33c6269f0608071302h6429cfcn71074709c5cd53ff@mail.gmail.com>
Date: Mon, 7 Aug 2006 16:02:52 -0400
From: "Alex Turner" <armtuk@gmail.com>
To: "Markus Schaber" <schabi@logix-tt.com>
Subject: Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
Cc: pgsql-performance@postgresql.org
In-Reply-To: <44D72D11.7050203@logix-tt.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_79917_28853215.1154980972903"
References: <7F10D26ECFA1FB458B89C5B4B0D72C2B4E4D9B@sesrv12.wirelesscar.com>
	<Pine.OSX.4.61.0607290153401.10025@white.nat.fasttrackmonkey.com>
	<44D72D11.7050203@logix-tt.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.374 tagged_above=0 required=5 tests=HTML_30_40,
	HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200608/83
X-Sequence-Number: 20268

------=_Part_79917_28853215.1154980972903
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Although I for one have yet to see a controller that actualy does this (I
believe software RAID on linux doesn't either).

Alex.

On 8/7/06, Markus Schaber <schabi@logix-tt.com> wrote:
>
> Hi, Charles,
>
> Charles Sprickman wrote:
>
> > I've also got a 1U with a 9500SX-4 and 4 drives.  I like how the 3Ware
> > card scales there - started with 2 drives and got "drive speed"
> > mirroring. Added two more and most of the bonnie numbers doubled.  This
> > is not what I'm used to with the Adaptec SCSI junk.
>
> Well, for sequential reading, you should be able to get double drive
> speed on a 2-disk mirror with a good controller, as it can balance the
> reads among the drives.
>
> Markus
> --
> Markus Schaber | Logical Tracking&Tracing International AG
> Dipl. Inf.     | Software Development GIS
>
> Fight against software patents in EU! www.ffii.org
> www.nosoftwarepatents.org
>
> ---------------------------(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
>

------=_Part_79917_28853215.1154980972903
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Although I for one have yet to see a controller that actualy does this (I believe software RAID on linux doesn't either).<br><br>Alex.<br><br><div><span class="gmail_quote">On 8/7/06, <b class="gmail_sendername">Markus Schaber
</b> &lt;<a href="mailto:schabi@logix-tt.com">schabi@logix-tt.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi, Charles,
<br><br>Charles Sprickman wrote:<br><br>&gt; I've also got a 1U with a 9500SX-4 and 4 drives.&nbsp;&nbsp;I like how the 3Ware<br>&gt; card scales there - started with 2 drives and got &quot;drive speed&quot;<br>&gt; mirroring. Added two more and most of the bonnie numbers doubled.&nbsp;&nbsp;This
<br>&gt; is not what I'm used to with the Adaptec SCSI junk.<br><br>Well, for sequential reading, you should be able to get double drive<br>speed on a 2-disk mirror with a good controller, as it can balance the<br>reads among the drives.
<br><br>Markus<br>--<br>Markus Schaber | Logical Tracking&amp;Tracing International AG<br>Dipl. Inf.&nbsp;&nbsp;&nbsp;&nbsp; | Software Development GIS<br><br>Fight against software patents in EU! <a href="http://www.ffii.org">www.ffii.org</a>
 <a href="http://www.nosoftwarepatents.org">www.nosoftwarepatents.org</a><br><br>---------------------------(end of broadcast)---------------------------<br>TIP 9: In versions below 8.0, the planner will ignore your desire to
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; choose an index scan if your joining column's datatypes do not<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; match<br></blockquote></div><br>

------=_Part_79917_28853215.1154980972903--