On Wed, Oct 30, 2002 at 10:59:39PM -0500, Tom Lane wrote: > > What's the basis for your assertion that it's "planning things that > don't need it"? Given a JOIN-constrained query I do not believe the > planner will look at any cases other than the intended join order.
Well, that was a loose choice of words - let's say the planner seems to be taking awfully long to build an execution tree with only one choice available. > He can do whatever he wants, as long as he has no illusions about > getting it accepted back into the sources ;-). Understood - this would be a hacking tool only. > What would probably be more useful is to do some profiling to understand > why the planner is taking longer than he wants even with a > JOIN-constrained query. I should think this would be pretty quick. Yup, that targets the same question as above - anything 'uneeded' actually happening in the planner? I'll send him off with this suggestion. Ross ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html