Re: Slow inner join, but left join is fast

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Slow inner join, but left join is fast
Дата
Msg-id 10060.1168449344@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Slow inner join, but left join is fast  ("Jeremy Haile" <jhaile@fastmail.fm>)
Ответы Re: Slow inner join, but left join is fast  ("Jeremy Haile" <jhaile@fastmail.fm>)
Список pgsql-performance
Дерево обсуждения 
"Jeremy Haile" <jhaile@fastmail.fm> writes:
> I have a query made by joining two subqueries where the outer query
> performing the join takes significantly longer to run than the two
> subqueries.

Please show EXPLAIN ANALYZE results, not just EXPLAIN.
Also, have you analyzed your tables recently?

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: tsuraan
Дата:
Сообщение: Re: group by will not use an index?
Следующее
От: "Jeremy Haile"
Дата:
Сообщение: Re: Slow inner join, but left join is fast