"=?gb18030?B?sKTM38jL?=" <2363541...@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 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 (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance