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
Jason Long mailing.li...@octgsoftware.com 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
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
On Fri, 2011-04-08 at 14:45 -0400, Tom Lane wrote:
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,