"=?gb18030?B?sKTM38jL?=" <[email protected]> writes:
> So, the question is, is there any way we can push join predicate into inner
> table ( we can disable merge join and hash join 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
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance