Simon Riggs wrote:
> IMHO we should have a single parameter which indicates how much planning
> time we consider acceptable for this query. e.g.
> optimization_level = 2 (default), varies 1-3
Couldn't the planner itself make a good guess if it should
keep trying based on the estimated cost?
Or maybe as simple as something like
if (time_spent_planning >= cost_of_the_best_plan_found / 10)
If we wanted a GUC, perhaps make it that 10 in the expression above?
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2008-06-26 21:23:18|
|Subject: Re: Planner creating ineffective plans on LEFT OUTER joins |
|Previous:||From: Josh Berkus||Date: 2008-06-26 21:04:07|
|Subject: Re: TODO Item: Allow pg_hba.conf to specify host names along with IP addresses|