Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D03159FC083 for ; Fri, 20 Jul 2007 14:18:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 11001-01 for ; Fri, 20 Jul 2007 14:18:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail136045.authsmtp.net (outmail136045.authsmtp.net [62.13.136.45]) by postgresql.org (Postfix) with ESMTP id 124449FC06F for ; Fri, 20 Jul 2007 14:18:01 -0300 (ADT) Received: from outmail128180.authsmtp.com (outmail128180.authsmtp.com [62.13.128.180]) by punt3.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l6KHHthE029021; Fri, 20 Jul 2007 18:17:58 +0100 (BST) Received: from [192.168.1.106] (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l6KHHsep004690; Fri, 20 Jul 2007 18:17:55 +0100 (BST) Message-ID: <46A0EE2F.4080100@agliodbs.com> Date: Fri, 20 Jul 2007 10:17:35 -0700 From: Josh Berkus User-Agent: Thunderbird 1.5.0.12 (Macintosh/20070509) MIME-Version: 1.0 To: Greg Smith CC: pgsql-performance@postgresql.org Subject: Re: User concurrency thresholding: where do I look? References: <200707190828.59088.josh@agliodbs.com> <20070719173704.GA12084@alvh.no-ip.org> <14009.1184867115@sss.pgh.pa.us> <200707191819.13899.josh@agliodbs.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: 27edaed7-36e5-11dc-867b-001185d377ca X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQL c1AAdh1xLVlbHwkB BHYKU15VV1d0XC1z bxRZbBtfZk9QXgRr T0pMQFdNFEs0B2d5 fl1LEhlycwNPeDBx ZE5iEHJcCRArIBJ6 X01SQGgbZGY0O30X VkcKagNUcQJCe0tG bVcsBT1vNG8XDRoV JSEUBRUEdQhEJT4d SQYLJk8IW0sNFS90 WxAYEC4vGkkJRiM8 fVQ5KlMGEQ4dNQ0T eV8mXlFPW3Vp X-Authentic-SMTP: 61633136333939.squirrel.dmpriest.net.uk:671/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/264 X-Sequence-Number: 25948 Greg, > There's so much going on with a TPC-C kind of workload. Has anyone ever > looked into quantifying scaling for more fundamental operations? There > are so many places a complicated workload could get caught up that > starting there is hard. I've found it's helpful to see the breaking > points for simpler operations, then compare how things change as each > new transaction element is introduced. ... eagerly awaiting Michael Doilson's PgUnitTest .... --Josh