Postgres Pro
Downloads
Home   >   mailing lists

Re: is there any way we can push join predicate into inner table - Mailing list pgsql-performance

From Tom Lane
Subject Re: is there any way we can push join predicate into inner table
Date
Msg-id 5676.1441031761@sss.pgh.pa.us
Whole thread Raw
In response to is there any way we can push join predicate into inner table  ("挨踢人" <2363541664@qq.com>)
List pgsql-performance
Tree view 
"=?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 by date:

Previous
From: "挨踢人"
Date:
Subject: is there any way we can push join predicate into inner table
Next
From: twoflower
Date:
Subject: Query > 1000× slowdown after adding datetime comparison