Re: What about utility to calculate planner cost constants? - Mailing list pgsql-performance

From Thomas F.O'Connell
Subject Re: What about utility to calculate planner cost constants?
Date
Msg-id 11322edfb476c82809712b9796f78a5f@sitening.com
Whole thread Raw
In response to Re: What about utility to calculate planner cost constants?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: What about utility to calculate planner cost constants?
List pgsql-performance
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.


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: What needs to be done for real Partitioning?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: What needs to be done for real Partitioning?