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 A5FC55296D for ; Wed, 6 Apr 2005 19:23:26 +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 47508-08 for ; Wed, 6 Apr 2005 18:23:18 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0BEF053364 for ; Wed, 6 Apr 2005 19:23:17 +0100 (BST) Received: from dyn-70-66.tor.dsl.tht.net (dyn-70-66.tor.dsl.tht.net [134.22.70.66]) by tht.net (Postfix) with ESMTP id 6A97C76A29; Wed, 6 Apr 2005 14:23:21 -0400 (EDT) Subject: Re: =?ISO-8859-1?Q?R=E9f?= From: Rod Taylor To: "Steinar H. Gunderson" Cc: pgsql-performance@postgresql.org In-Reply-To: <20050406174254.GC13641@uio.no> References: <1112807909.92363.120.camel@home> <20050406174254.GC13641@uio.no> Content-Type: text/plain Date: Wed, 06 Apr 2005 14:23:10 -0400 Message-Id: <1112811790.92363.123.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1.1 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/115 X-Sequence-Number: 11512 On Wed, 2005-04-06 at 19:42 +0200, Steinar H. Gunderson wrote: > On Wed, Apr 06, 2005 at 01:18:29PM -0400, Rod Taylor wrote: > > Yeah, I think that can be done provided there is more than one worker. > > My limit seems to be about 1000 transactions per second each with a > > single insert for a single process (round trip time down the Fibre > > Channel is large) but running 4 simultaneously only drops throughput to > > about 900 per process (total of 2400 transactions per second) and the > > machine still seemed to have lots of oomph to spare. > > Erm, have I missed something here? 900 * 4 = 2400? Nope. You've not missed anything. If I ran 10 processes and the requirement would be met. --