Re: is there any way we can push join predicate into inner table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: is there any way we can push join predicate into inner table
Дата
Msg-id 5676.1441031761@sss.pgh.pa.us
обсуждение исходный текст
Ответ на is there any way we can push join predicate into inner table  ("挨踢人" <2363541664@qq.com>)
Список pgsql-performance
Дерево обсуждения 
"=?gb18030?B?sKTM38jL?=" <2363541664@qq.com> writes:
>  So, the question is, is there any way we can push join predicate into inner table ( we can disable merge join and
hashjoin to get NL Join, but join predicate is not able to push into inner table )? 

You probably need to turn on use_remote_estimate; postgres_fdw won't
consider parameterized paths without that, because it has no way to
compare costs.

            regards, tom lane

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

Предыдущее
От: "挨踢人"
Дата:
Сообщение: is there any way we can push join predicate into inner table
Следующее
От: twoflower
Дата:
Сообщение: Query > 1000× slowdown after adding datetime comparison