X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C681D52A06 for ; Fri, 19 Aug 2005 13:34:52 -0300 (ADT) 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 76579-06 for ; Fri, 19 Aug 2005 16:34:50 +0000 (GMT) Received: from gghcwest.com (adsl-71-128-90-172.dsl.pltn13.pacbell.net [71.128.90.172]) by svr1.postgresql.org (Postfix) with ESMTP id 121C952990 for ; Fri, 19 Aug 2005 13:34:48 -0300 (ADT) Received: from toonses.gghcwest.com (toonses.gghcwest.com [192.168.168.115]) by gghcwest.com (8.12.10/8.12.9) with ESMTP id j7JGYimd027052; Fri, 19 Aug 2005 09:34:44 -0700 Received: from jwb by toonses.gghcwest.com with local (Exim 4.50) id 1E69pN-0007nY-4t; Fri, 19 Aug 2005 09:34:45 -0700 Subject: Re: sustained update load of 1-2k/sec From: "Jeffrey W. Baker" To: Ron Cc: pgsql-performance@postgresql.org In-Reply-To: <6.2.3.4.0.20050819093011.05c1b9d8@pop.earthlink.net> References: <20050819082404.53751.qmail@web32915.mail.mud.yahoo.com> <33c6269f050819054038af9886@mail.gmail.com> <6.2.3.4.0.20050819093011.05c1b9d8@pop.earthlink.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Fri, 19 Aug 2005 09:34:44 -0700 Message-Id: <1124469284.29778.4.camel@toonses.gghcwest.com> Mime-Version: 1.0 X-Mailer: Evolution 2.3.6.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-0.841 required=5 tests=[AWL=-0.891, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/269 X-Sequence-Number: 14016 On Fri, 2005-08-19 at 10:54 -0400, Ron wrote: > Maxtor Atlas 15K II's. > Areca's 1GB buffer RAID cards The former are SCSI disks and the latter is an SATA controller. The combination would have a transaction rate of approximately 0. I can vouch for the Areca controllers, however. You can certainly achieve pgbench transaction rates in the hundreds per second even with only 5 7200RPM disks and 128MB cache. Don't forget to buy the battery. -jwb