From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | mailing(dot)lists(at)octgsoftware(dot)com |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: comma vs cross join question |
Date: | 2011-04-08 18:24:10 |
Message-ID: | 15744.1302287050@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jason Long <mailing(dot)lists(at)octgsoftware(dot)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
> query is identical to what was there before and takes less than 300 ms.
Those should be semantically equivalent AFAICS. Do you maybe have
join_collapse_limit set to a smaller-than-default value? If not, are
any of those tables really join views?
Please see
http://wiki.postgresql.org/wiki/SlowQueryQuestions
if you need further help, because there's not enough information here
to do more than guess wildly.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2011-04-08 18:39:52 | Re: PostgreSQL backend process high memory usage issue |
Previous Message | Tom Lane | 2011-04-08 18:08:52 | Re: Changed SSL Certificates |