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 C99D25370F for ; Thu, 7 Apr 2005 05:15:30 +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 19813-10 for ; Thu, 7 Apr 2005 04:15:21 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id C25F152808 for ; Thu, 7 Apr 2005 05:15:20 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j374Evq4013450; Thu, 7 Apr 2005 00:14:57 -0400 (EDT) To: Greg Stark Cc: Alex Turner , "Jim C. Nasby" , William Yu , pgsql-performance@postgresql.org Subject: Re: How to improve db performance with $7K? In-reply-to: <87wtrfmgt5.fsf@stark.xeocode.com> References: <424840AE.3050200@sfnet.cc> <42494741.7060806@fastcrypt.com> <33c6269f0504040643317b69cd@mail.gmail.com> <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> Comments: In-reply-to Greg Stark message dated "06 Apr 2005 23:00:54 -0400" Date: Thu, 07 Apr 2005 00:14:57 -0400 Message-ID: <13449.1112847297@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/142 X-Sequence-Number: 11539 Greg Stark writes: > 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. That's the bottom line: the SCSI protocol was designed (twenty years ago!) to allow the drive to do physical I/O scheduling, because the CPU can issue multiple commands before the drive has to report completion of the first one. IDE isn't designed to do that. I understand that the latest revisions to the IDE/ATA specs allow the drive to do this sort of thing, but support for it is far from widespread. regards, tom lane