Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C2E8164FD14 for ; Thu, 11 Dec 2008 16:05:16 -0400 (AST) 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 69736-03 for ; Thu, 11 Dec 2008 16:05:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128152.authsmtp.co.uk (outmail128152.authsmtp.co.uk [62.13.128.152]) by mail.postgresql.org (Postfix) with ESMTP id AD52464FD00 for ; Thu, 11 Dec 2008 16:05:13 -0400 (AST) 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 mBBK5B4q007176 for ; Thu, 11 Dec 2008 20:05:11 GMT Received: from josh-berkuss-macbook.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id mBBK58gj078388 for ; Thu, 11 Dec 2008 20:05:09 GMT Message-ID: <49417274.90408@agliodbs.com> Date: Thu, 11 Dec 2008 12:05:08 -0800 From: Josh Berkus Organization: Aglio Database Solutions User-Agent: Thunderbird 2.0.0.18 (Macintosh/20081105) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Need help with 8.4 Performance Testing References: <200812071138.01215.josh@agliodbs.com> <87y6ypijsl.fsf@oxford.xeocode.com> In-Reply-To: <87y6ypijsl.fsf@oxford.xeocode.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: 0370f398-c7bf-11dd-bc7a-001f29070be2 X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkbIhBDJB8RWB5f NVxfJ1xYPXUEQkpF VCReGBUITgIzDi10 ahUlOFZCYEpOVxVo UEJJR1hTFEtuBQIJ BwAcVhxsdgRHZ3x1 Z0N9Xj4GLjYBcE4q GE5THW4ObSlhamIe HkBbcAMCcwpCY0xC OAZiVXJZNXhVNX0x WldrZj5rbG0AcC5Y GBc3IABaZ0sGEnY8 ShQaVSouAU1NF2Nv ZyQrMFAbBkMYNE4/ eWcsQk4ZNRB6 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: 200812/135 X-Sequence-Number: 32171 > I would expect higher shared_buffers to raise the curve before the first > breakpoint but after the first breakpoint make the drop steeper and deeper. > The equilibrium where the curve becomes flatter should be lower. On SpecJAppserver specifically, I remember seeing a drop when the database size grew beyond the size of shared_buffers. --Josh