Re: LEFT JOIN ON vs. LEFT JOIN USING performance

От: Tom Lane
Тема: Re: LEFT JOIN ON vs. LEFT JOIN USING performance
Дата: ,
Msg-id: 25396.1124466049@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: LEFT JOIN ON vs. LEFT JOIN USING performance  ("Diego de Lima")
Список: 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 по дате сообщения:

От: Ron
Дата:
Сообщение: Re: sustained update load of 1-2k/sec
От: Mark Cotner
Дата:
Сообщение: Re: sustained update load of 1-2k/sec