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