考虑到这个查询:
select *
from fdw_schema.customer c
where exists
( select *
from fdw_schema.purchase p
where c.id = p.customer_id
and p.purchase_date > now() - interval '30 days');
整个查询会被postgres_fdw推倒到远程服务器上吗?
我的选择是:
select distinct c.*
from fdw_schema.customer c
join fdw_schema.purch