Re: [PERFORM] LEFT JOIN ON vs. LEFT JOIN USING performance

2005-08-19 Thread John A Meinel
Diego de Lima wrote: > Hi list, > > I´m using Pg 8.0.3 on Linux FC2. > > This question may have a very simple answer (I hope), but I´m having > lots of trouble solving it, and I counldn´t find any other post about it > or anything in the pg docs. > > I have some very complex select statements

Re: [PERFORM] LEFT JOIN ON vs. LEFT JOIN USING performance

2005-08-19 Thread Tom Lane
"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 s

[PERFORM] LEFT JOIN ON vs. LEFT JOIN USING performance

2005-08-19 Thread Diego de Lima
Hi list,   I´m using Pg 8.0.3 on Linux FC2.   This question may have a very simple answer (I hope), but I´m having lots of trouble solving it, and I counldn´t find any other post about it or anything in the pg docs.   I have some very complex select statements on 4 million rows tables. When u