Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D7EF19FB6E3 for ; Wed, 9 May 2007 08:36:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 12618-09 for ; Wed, 9 May 2007 08:36:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from oxford.xeocode.com (unknown [62.232.55.118]) by postgresql.org (Postfix) with ESMTP id 4B2B99FB5CD for ; Wed, 9 May 2007 08:36:28 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.67) (envelope-from ) id 1HlkSy-0001JF-2a; Wed, 09 May 2007 12:36:20 +0100 From: Gregory Stark To: Cc: "Orhan Aglagul" , Subject: Re: FW: In-Reply-To: (david@lang.hm's message of "Tue, 8 May 2007 18:22:45 -0700 (PDT)") Organization: EnterpriseDB References: <868BCE5A6576F44A862F1FBBC3E14A0104255AFA@ms17.mse9.exchange.ms> X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 291) Date: Wed, 09 May 2007 12:36:19 +0100 Message-ID: <87d51ai5zg.fsf@oxford.xeocode.com> User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/21.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/180 X-Sequence-Number: 24570 writes: > with a standard 7200 rpm drive ~150 transactions/sec sounds about right > > to really speed things up you want to get a disk controller with a battery > backed cache so that the writes don't need to hit the disk to be safe. Note that this is only if you're counting transactions/sec in a single session. You can get much more if you have many sessions since they can all commit together in a single disk i/o. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com