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 E25C5534C8 for ; Wed, 6 Apr 2005 19:40: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 55084-06 for ; Wed, 6 Apr 2005 18:40:30 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by svr1.postgresql.org (Postfix) with ESMTP id 7289B534BD for ; Wed, 6 Apr 2005 19:40:29 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 68so342408wri for ; Wed, 06 Apr 2005 11:40:31 -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=ccImMf1CrnnTqy60sbQkswe11ak9uxpYcxUdzBdmLzy4NvoX5EVArggsiLlrkwhjb/cDHKug+x8Ji92XqSnlNJ2n2Y0oAuSU6sLrmVAENgLAObkuZRLq3J4bw401RLUH31VFYhLmGtqarQ+S1d8oMRQp5yFobdoQ23ffaYHfO2Y= Received: by 10.54.32.67 with SMTP id f67mr250477wrf; Wed, 06 Apr 2005 11:40:30 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Wed, 6 Apr 2005 11:40:29 -0700 (PDT) Message-ID: <33c6269f0504061140363ac662@mail.gmail.com> Date: Wed, 6 Apr 2005 14:40:29 -0400 From: Alex Turner Reply-To: Alex Turner To: Rod Taylor Subject: =?ISO-8859-1?Q?Re:__R=E9f?= Cc: "Steinar H. Gunderson" , pgsql-performance@postgresql.org In-Reply-To: <1112811790.92363.123.camel@home> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <1112807909.92363.120.camel@home> <20050406174254.GC13641@uio.no> <1112811790.92363.123.camel@home> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.254 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/117 X-Sequence-Number: 11514 I think his point was that 9 * 4 != 2400 Alex Turner netEconomist On Apr 6, 2005 2:23 PM, Rod Taylor wrote: > 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. > -- > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >