Queries that reference multiple foreign tables can perform table scans in parallel. This is implemented in the postgres_fdw
postgres_fdw