Re: LEFT JOIN ON vs. LEFT JOIN USING performance

From: Tom Lane
Subject: Re: LEFT JOIN ON vs. LEFT JOIN USING performance
Date: ,
Msg-id: 25396.1124466049@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: LEFT JOIN ON vs. LEFT JOIN USING performance  ("Diego de Lima")
List: pgsql-performance

"Diego de Lima" <> 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


pgsql-performance by date:

From: Ron
Date:
Subject: Re: sustained update load of 1-2k/sec
From: Mark Cotner
Date:
Subject: Re: sustained update load of 1-2k/sec