I haven't used FDW directly but I would suspect the performance would largely be related to how you can get pushdown and native usage within the source system.

I haven't used FDW directly but I would suspect the performance would largely be related to how you can get pushdown and native usage within the source system. Combining data almost must be done on the master node.