Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1C67E6334DB for ; Sun, 29 Mar 2009 18:33:53 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96989-06 for ; Sun, 29 Mar 2009 18:33:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136046.authsmtp.co.uk (outmail136046.authsmtp.co.uk [62.13.136.46]) by mail.postgresql.org (Postfix) with ESMTP id 758E46323E8 for ; Sun, 29 Mar 2009 18:33:41 -0300 (ADT) Received: from mail-c189.authsmtp.com (mail-c189.authsmtp.com [62.13.128.71]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2TLXZ2q035926; Sun, 29 Mar 2009 22:33:35 +0100 (BST) Received: from Sidney-Stratton.local (adsl-63-195-55-98.dsl.snfc21.pacbell.net [63.195.55.98]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2TLXWI3011748; Sun, 29 Mar 2009 22:33:33 +0100 (BST) Message-ID: <49CFE92A.8000101@agliodbs.com> Date: Sun, 29 Mar 2009 14:33:30 -0700 From: Josh Berkus Organization: Aglio Database Solutions User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: "Jignesh K. Shah" CC: decibel@decibel.org, Tom Lane , Scott Carey , Kevin Grittner , pgsql-performance@postgresql.org Subject: Re: Proposal of tunable fix for scalability of 8.4 References: <29836.1236826066@sss.pgh.pa.us> <49B8861C.2000005@sun.com> <1E9C2E4B-4C0C-4343-B244-388DA2047870@decibel.org> <49BD67A4.7020106@sun.com> In-Reply-To: <49BD67A4.7020106@sun.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: 41bc6b09-1ca9-11de-bc7b-001f29070be2 X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQP c1AAfx12OUdbHwkB CnYJWV5XU1dyXS1z aBRQZABDZ09QVg11 Uk1LR01SWltqZWBp YWcdUhhzcAFONn91 Z0AsWnEJD0IodU9g Qx0FHHAHZDM1dTJM VxJFdwNVJgFDfhhF OAV9GhFYa3VsBg8C MSgJGgV5BS9YMCNO SwVFKlxaXVsNFzQ4 SlgMHCVnE0ofDz44 JhgvIF8YHVoAekI8 eQtnBTpf X-Authentic-SMTP: 61633136333939.kestrel.dmpriest.net.uk:1378/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-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/401 X-Sequence-Number: 33323 On 3/15/09 1:40 PM, Jignesh K. Shah wrote: > > > decibel wrote: >> On Mar 11, 2009, at 10:48 PM, Jignesh K. Shah wrote: >>> Fair enough.. Well I am now appealing to all who has a fairly decent >>> sized hardware want to try it out and see whether there are "gains", >>> "no-changes" or "regressions" based on your workload. Also it will >>> help if you report number of cpus when you respond back to help >>> collect feedback. EAStress (the J2EE benchmark from Spec) would be perfect for this, and we (community) have a license for it. However, EAstress really requires 2-3 J2EE servers to keep the DB server busy. --Josh