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 A22D25334D for ; Mon, 4 Apr 2005 20:23:37 +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 32441-01 for ; Mon, 4 Apr 2005 19:23:36 +0000 (GMT) Received: from yertle.kcilink.com (yertle.kcilink.com [65.205.34.180]) by svr1.postgresql.org (Postfix) with ESMTP id 43BD952A5C for ; Mon, 4 Apr 2005 20:23:33 +0100 (BST) Received: from [192.168.7.103] (host-103.int.kcilink.com [192.168.7.103]) by yertle.kcilink.com (Postfix) with ESMTP id 8F7DCB80C for ; Mon, 4 Apr 2005 15:23:33 -0400 (EDT) Mime-Version: 1.0 (Apple Message framework v619.2) In-Reply-To: <33c6269f05040412126b5bc719@mail.gmail.com> References: <42443863.4040302@sfnet.cc> <42453273.2060509@turtle-entertainment.de> <200503261255.59007.josh@agliodbs.com> <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> Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Vivek Khera Subject: Re: How to improve db performance with $7K? Date: Mon, 4 Apr 2005 15:23:33 -0400 To: pgsql-performance@postgresql.org X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.143 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/60 X-Sequence-Number: 11457 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