Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 979DE9FBAC2 for ; Wed, 4 Apr 2007 12:33:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 81989-06-3 for ; Wed, 4 Apr 2007 12:33:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id 1B8C79FBB60 for ; Wed, 4 Apr 2007 12:33:28 -0300 (ADT) Received: from congw.dc1.conova.com ([217.196.145.250] helo=[192.168.1.61]) by cronos.madness.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1HZ7U1-0001QX-SZ; Wed, 04 Apr 2007 17:33:22 +0200 Message-ID: <4613C54C.4050207@kaltenbrunner.cc> Date: Wed, 04 Apr 2007 17:33:32 +0200 From: Stefan Kaltenbrunner User-Agent: Icedove 1.5.0.10 (X11/20070307) MIME-Version: 1.0 To: "Joshua D. Drake" CC: "jason@ohloh.net" , Geoff Tolley , pgsql-performance@postgresql.org Subject: Re: SCSI vs SATA References: <9C0858F5-0A48-4AF9-80FF-E4BA14F0F965@ohloh.net> <4613053F.5070401@polimetrix.com> <4613C14A.4020703@commandprompt.com> In-Reply-To: <4613C14A.4020703@commandprompt.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/72 X-Sequence-Number: 23949 Joshua D. Drake wrote: > >> >> Good point. On another note, I am wondering why nobody's brought up >> the command-queuing perf benefits (yet). Is this because sata vs scsi >> are at > > SATAII has similar features. > >> par here? I'm finding conflicting information on this -- some calling >> sata's ncq mostly crap, others stating the real-world results are >> negligible. I'm inclined to believe SCSI's pretty far ahead here but >> am having trouble finding recent articles on this. > > What I find is, a bunch of geeks sit in a room and squabble about a few > percentages one way or the other. One side feels very l33t because their > white paper looks like the latest swimsuit edition. > > Real world specs and real world performance shows that SATAII performs, > very, very well. It is kind of like X86. No chip engineer that I know > has ever said, X86 is elegant but guess which chip design is conquering > all others in the general and enterprise marketplace? > > SATAII brute forces itself through some of its performance, for example > 16MB write cache on each drive. sure but for any serious usage one either wants to disable that cache(and rely on tagged command queuing or how that is called in SATAII world) or rely on the OS/raidcontroller implementing some sort of FUA/write barrier feature(which linux for example only does in pretty recent kernels) Stefan