On Fri, 2011-04-08 at 14:45 -0400, Tom Lane wrote:
> Jason Long 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
Jason Long 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_colla
Jason Long writes:
> I recently upgraded to JBoss AS 6.0.0.Final which includes a newer
> version of Hibernate.
> Previously the Postgres dialect was using a comma, but now is is using
> cross join.
> With the cross join this query never completes. With the comma the
> query is identical to what
I recently upgraded to JBoss AS 6.0.0.Final which includes a newer
version of Hibernate.
Previously the Postgres dialect was using a comma, but now is is using
cross join.
In order do to the migration I had to override the cross join operator
to a comma in HIbernate so it would generate the same
