Re: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.
Дата
Msg-id 16847.1486485453@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [SQL] why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.  (Herwig Goemans <herwig.goemans@gmail.com>)
Ответы Re: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting inbad performance.  (Herwig Goemans <herwig.goemans@gmail.com>)
Список pgsql-sql
Дерево обсуждения 
Herwig Goemans <herwig.goemans@gmail.com> writes:
> I am wondering why a certain query is NOT pushing the where clause to the
> view. See query and explain plan:

There's no provision for transitively applying IN clauses to other
variables.  I'm not entirely sure whether it would be a good idea,
but in any case, it's not there and not planned.
        regards, tom lane

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

Предыдущее
От: Herwig Goemans
Дата:
Сообщение: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.
Следующее
От: Herwig Goemans
Дата:
Сообщение: Re: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting inbad performance.