Re: optimizing away join when querying view

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: optimizing away join when querying view
Дата
Msg-id 7893.1139413057@sss.pgh.pa.us
обсуждение исходный текст
Ответ на optimizing away join when querying view  (Jacob Costello <jake@suntradingllc.com>)
Список pgsql-performance
Jacob Costello <jake@suntradingllc.com> writes:
> Postgres doesn't seem to optimize away unnecessary joins

There is no such thing as an unnecessary join, unless you are willing to
stake the correctness of the query on constraints that could be dropped
after the query is planned.  Until we have some infrastructure to deal
with that situation, nothing like this is going to happen.

            regards, tom lane

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

Предыдущее
От: Ron
Дата:
Сообщение: Size and performance hit from using UTF8 vs. ASCII?
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: optimizing away join when querying view