Ben Chobot <bench@xxxxxxxxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
