Jason Long <mailing.lists@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
