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 A9DCA53400 for ; Mon, 4 Apr 2005 20:33:39 +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 35427-01 for ; Mon, 4 Apr 2005 19:33:36 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by svr1.postgresql.org (Postfix) with ESMTP id BD958533EE for ; Mon, 4 Apr 2005 20:33:35 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 68so1682068wri for ; Mon, 04 Apr 2005 12:33:36 -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=VKPaixeRReUD1eVAV66JWa6rOk0Xiec5aI0o73X/M84ayqjFDM5uyJpIzu/cFYitebMfrq8s6K/YfezkBcjHelB0EhNVkcdEfsvTCLTojrrVC+AySZ4fRqRxRqnP7NpRW18QfnTfgVzPmGebR0xy3YM6c8lqzegDMv2ZW0KWAtY= Received: by 10.54.7.36 with SMTP id 36mr79801wrg; Mon, 04 Apr 2005 12:33:36 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Mon, 4 Apr 2005 12:33:35 -0700 (PDT) Message-ID: <33c6269f05040412336cbfe3b4@mail.gmail.com> Date: Mon, 4 Apr 2005 15:33:35 -0400 From: Alex Turner Reply-To: Alex Turner To: Vivek Khera Subject: Re: How to improve db performance with $7K? Cc: pgsql-performance@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <42443863.4040302@sfnet.cc> <42455DEC.2080301@sfnet.cc> <1112049794.23284.29.camel@localhost.localdomain> <424840AE.3050200@sfnet.cc> <42494741.7060806@fastcrypt.com> <33c6269f0504040643317b69cd@mail.gmail.com> <42515198.9090903@sfnet.cc> <33c6269f05040412126b5bc719@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.249 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/61 X-Sequence-Number: 11458 I'm doing some research on SATA vs SCSI right now, but to be honest I'm not turning up much at the protocol level. Alot of stupid benchmarks comparing 10k Raptor drives against Top of the line 15k drives, where usnurprsingly the SCSI drives win but of course cost 4 times as much. Although even in some, SATA wins, or draws. I'm trying to find something more apples to apples. 10k to 10k. Alex Turner netEconomist On Apr 4, 2005 3:23 PM, Vivek Khera wrote: > > On Apr 4, 2005, at 3:12 PM, Alex Turner wrote: > > > Our system is mostly read during the day, but we do a full system > > update everynight that is all writes, and it's very fast compared to > > the smaller SCSI system we moved off of. Nearly a 6x spead > > improvement, as fast as 900 rows/sec with a 48 byte record, one row > > per transaction. > > > > Well, if you're not heavily multitasking, the advantage of SCSI is lost > on you. > > Vivek Khera, Ph.D. > +1-301-869-4449 x806 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >