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