Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A912D6336CA for ; Tue, 17 Mar 2009 06:17:47 -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 33127-09 for ; Tue, 17 Mar 2009 06:17:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128144.authsmtp.com (outmail128144.authsmtp.com [62.13.128.144]) by mail.postgresql.org (Postfix) with ESMTP id 55E466335DA for ; Tue, 17 Mar 2009 06:17:44 -0300 (ADT) Received: from mail-c188.authsmtp.com (mail-c188.authsmtp.com [62.13.128.25]) by punt10.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2H9HgD7047652; Tue, 17 Mar 2009 09:17:42 GMT Received: from [192.168.0.2] (85-211-223-92.dyn.gotadsl.co.uk [85.211.223.92]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2H9HeN7048597; Tue, 17 Mar 2009 09:17:40 GMT Subject: Re: Proposal of tunable fix for scalability of 8.4 From: Simon Riggs To: "Jignesh K. Shah" Cc: Tom Lane , Kevin Grittner , pgsql-performance@postgresql.org In-Reply-To: <49B87161.10201@sun.com> References: <49B824DD.7090302@sun.com> <49B7F470.EE98.0025.0@wicourts.gov> <29080.1236821556@sss.pgh.pa.us> <49B87161.10201@sun.com> Content-Type: text/plain Date: Mon, 16 Mar 2009 17:39:58 +0000 Message-Id: <1237225198.3963.60.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 776679bc-12d4-11de-aecc-001871e930f4 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksachtFaQJbYFhD HGQLW11EUFR7WGR/ bwsfZQBDYEtPQQdo U1ZAQE1QEQdtHhxP WBxmW2EnCQJGfHZ1 bEEsV3lZEkN9c0B6 SxwHCGwEMWN9aWFL BV0JIlAHbQNKfxdC awV2V3NbZStlM3Bw LDceBR4WBxBqYBxP RRkKNlsWCUEFViIh QRkIGThnE0wVDys0 NVQ9IVcYFUwQNkQu IBMmVxpIdUN6 X-Authentic-SMTP: 61633235383639.cat.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.869 tagged_above=0 required=5 tests=AWL=-0.901, DATE_IN_PAST_12_24=1.77 X-Spam-Level: X-Archive-Number: 200903/229 X-Sequence-Number: 33151 On Wed, 2009-03-11 at 22:20 -0400, Jignesh K. Shah wrote: > A tunable does not impact existing behavior Why not put the tunable parameter into the patch and then show the test results with it in? If there is no overhead, we should then be able to see that. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support