Re: comma vs cross join question

Jason Long <mailing.lists@octgsoftware.com> writes:
> I am using 9.0.3 and the only setting I have changed is
> geqo_effort = 10

> One of the joins is a view join.

Ah.  The explain shows there are actually nine base tables in that
query, which is more than the default join_collapse_limit.  Try cranking
up both join_collapse_limit and from_collapse_limit to 10 or so.
(I'm not sure offhand if from_collapse_limit affects this case, but it
might.)

            regards, tom lane