X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 570AB568E6 for ; Mon, 21 Mar 2005 18:18:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84490-10 for ; Mon, 21 Mar 2005 18:18:24 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 5346D567DD for ; Mon, 21 Mar 2005 18:18:22 +0000 (GMT) Received: (qmail 24998 invoked from network); 21 Mar 2005 18:18:22 -0000 Received: from host-209.149.56.238.nashville.net (HELO ?10.0.1.2?) (209.149.56.238) by 0 with SMTP; 21 Mar 2005 18:18:22 -0000 In-Reply-To: <200503210951.06044.josh@agliodbs.com> References: <200503210951.06044.josh@agliodbs.com> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <11322edfb476c82809712b9796f78a5f@sitening.com> Content-Transfer-Encoding: 7bit Cc: "Tambet Matiisen" , From: Thomas F.O'Connell Subject: Re: What about utility to calculate planner cost constants? Date: Mon, 21 Mar 2005 12:18:17 -0600 To: Josh Berkus X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/422 X-Sequence-Number: 11127 If by not practical you mean, "no one has implemented a multivariable testing approach," I'll agree with you. But multivariable testing is definitely a valid statistical approach to solving just such problems. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Mar 21, 2005, at 11:51 AM, Josh Berkus wrote: > That's not really practical. There are currently 5 major query tuning > parameters, not counting the memory adjustments which really can't be > left > out. You can't realistically test all combinations of 6 variables.