Ben Chobot <[email protected]> writes:
> Awesome, that did the trick. Thanks Tom! So I understand better, why is my
> case not the normal, better case?
Well, the short answer is that the 8.4 changes here are in the nature of
two steps forward and one step back. The long-term goal is to increase
the planner's ability to choose among different join orders; but we're
getting rid of one restriction at a time, and sometimes the interactions
of those restrictions produce unwanted results like the older code being
able to find a better plan than the new code can.
> (I assume the long-term fix is post-9.0, right?)
Yeah, fraid so. I've been mostly buried in non-planner work in the 9.0
cycle, but hope to get back to this and other problems in the next
cycle.
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
