On Wed, 2005-12-14 at 21:27 -0500, Tom Lane wrote: > I've spent some time looking into how we can improve our planning of outer > joins.
Sounds good. > I'm not sure whether we'd need any additional planner knobs to control > this. I think that the existing join_collapse_limit GUC variable should > continue to exist, but its effect on left/right joins will be the same as > for inner joins. If anyone wants to force join order for outer joins more > than for inner joins, we'd need some other control setting, but I don't > currently see why that would be very useful. Agreed. No additional GUCs required. > Does this seem like a reasonable agenda Yup - tis good. Best Regards, Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq