Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A11446331DC for ; Sat, 14 Mar 2009 10:30:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 00111-09 for ; Sat, 14 Mar 2009 10:30:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136038.authsmtp.com (outmail136038.authsmtp.com [62.13.136.38]) by mail.postgresql.org (Postfix) with ESMTP id BC04E63269A for ; Sat, 14 Mar 2009 10:30:18 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2EDUF14046246; Sat, 14 Mar 2009 13:30:15 GMT Received: from [192.168.0.3] (85-211-101-172.dyn.gotadsl.co.uk [85.211.101.172]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2EDUEKA089911; Sat, 14 Mar 2009 13:30:14 GMT Subject: Re: Proposal of tunable fix for scalability of 8.4 From: Simon Riggs To: "Jignesh K. Shah" Cc: pgsql-performance@postgresql.org In-Reply-To: <49B824DD.7090302@sun.com> References: <49B824DD.7090302@sun.com> Content-Type: text/plain Date: Sat, 14 Mar 2009 13:30:02 +0000 Message-Id: <1237037402.3963.36.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 408186db-109c-11de-8a51-002264978518 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaQFbYFhD HGQLW11EUV57WmN/ ag8fZQBDYEtPQQRq UVZIRVBNFgBqBAMB SEAcJ20XAn43eHZ5 bEdjEHFbWEE0cUZ1 Q0ZSQT8bZGdpO30e URQNagsFdQJXfh9H aFZ7XXQFZGQPKBg1 TUcABx0LExJlDREd ehsKNVUJSEJDGTB0 Ww0EFD8rEAULRjV7 IRs8YkUXFUIYOEQ2 MEcwEVUWe09UVmUg X-Authentic-SMTP: 61633235383639.pelican.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-Archive-Number: 200903/187 X-Sequence-Number: 33109 On Wed, 2009-03-11 at 16:53 -0400, Jignesh K. Shah wrote: > 1200: 2000: Medium Throughput: -1781969.000 Avg Medium Resp: 0.019 I think you need to iron out bugs in your test script before we put too much stock into the results generated. Your throughput should not be negative. I'd be interested in knowing the number of S and X locks requested, so we can think about this from first principles. My understanding is that ratio of S:X is about 10:1. Do you have more exact numbers? -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support