"Diego de Lima" <[EMAIL PROTECTED]> writes:
> I have some very complex select statements on 4 million rows tables. =
> When using LEFT JOIN ON, some select statements takes about 2 minutes. =
> When I write exactly the same statement but with LEFT JOIN USING, it =
> takes only 1 minute.

Could we see details please?  Like the table schemas, the query itself,
and EXPLAIN ANALYZE results for both cases.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to