X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8E55E534EB for ; Thu, 7 Apr 2005 04:06:57 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00627-08 for ; Thu, 7 Apr 2005 03:06:48 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by svr1.postgresql.org (Postfix) with ESMTP id 7CA1252808 for ; Thu, 7 Apr 2005 04:06:47 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 68so472703wri for ; Wed, 06 Apr 2005 20:06:47 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=ZFEC3w387ECgBLZdxsVR8hpC2ePs+r8gvL31P+p8ig4hddJYyv8b0gymEJbQFn8GDzbXe1mm2NM0SWMZ5hLVDYxwNdtEK7HqJjO8Tb1/LuzYWp2q8w3/mBK/4jDZZlCLbg+nU+r/Tkc1fEHuJz/XXR/kNrKuhmJlj6yKRXAJvcA= Received: by 10.54.15.26 with SMTP id 26mr1319088wro; Wed, 06 Apr 2005 20:06:47 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Wed, 6 Apr 2005 20:06:47 -0700 (PDT) Message-ID: <33c6269f050406200623d43daf@mail.gmail.com> Date: Wed, 6 Apr 2005 22:06:47 -0500 From: Alex Turner Reply-To: Alex Turner To: Greg Stark Subject: Re: How to improve db performance with $7K? Cc: "Jim C. Nasby" , William Yu , pgsql-performance@postgresql.org In-Reply-To: <87wtrfmgt5.fsf@stark.xeocode.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <424840AE.3050200@sfnet.cc> <42515198.9090903@sfnet.cc> <33c6269f05040412126b5bc719@mail.gmail.com> <33c6269f050406083533d2045d@mail.gmail.com> <33c6269f050406151241b01148@mail.gmail.com> <20050406224102.GM93835@decibel.org> <33c6269f0504061732195f6ae4@mail.gmail.com> <87wtrfmgt5.fsf@stark.xeocode.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.257 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/140 X-Sequence-Number: 11537 Yeah - the more reading I'm doing - the more I'm finding out. Alledgelly the Western Digial Raptor drives implement a version of ATA-4 Tagged Queing which allows reordering of commands. Some controllers support this. The 3ware docs say that the controller support both reordering on the controller and to the drive. *shrug* This of course is all supposed to go away with SATA II which as NCQ, Native Command Queueing. Of course the 3ware controllers don't support SATA II, but a few other do, and I'm sure 3ware will come out with a controller that does. Alex Turner netEconomist On 06 Apr 2005 23:00:54 -0400, Greg Stark wrote: > > Alex Turner writes: > > > SATA gives each drive it's own channel, but you have to share in SCSI. > > A SATA controller typicaly can do 3Gb/sec (384MB/sec) per drive, but > > SCSI can only do 320MB/sec across the entire array. > > SCSI controllers often have separate channels for each device too. > > In any case the issue with the IDE protocol is that fundamentally you can only > have a single command pending. SCSI can have many commands pending. This is > especially important for a database like postgres that may be busy committing > one transaction while another is trying to read. Having several commands > queued on the drive gives it a chance to execute any that are "on the way" to > the committing transaction. > > However I'm under the impression that 3ware has largely solved this problem. > Also, if you save a few dollars and can afford one additional drive that > additional drive may improve your array speed enough to overcome that > inefficiency. > > -- > greg > >