"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