Jason Long <mailing.li...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
