Foreign table as partition - Non optimal aggregation plan

Hi All! We are using such feature as Foreign table as partition in PG 13 under CentOS Here is our table CREATE TABLE dwh.l1_snapshot ( l1_snapshot_id int8 NOT NULL DEFAULT nextval('sq_l1_snapshot_id'::regclass), start_date_id int4 NULL, ... ... ... dataset_id int4 NULL, --

FDW join vs full join push down

Hello all, We have some PG servers which we merge into a "coordinator" node using FDW and partitioned tables, we partition them by a synthetic "shard_id" field. There are around 30 tables coordinated this way, with all foreign servers having the same schema structure. We have some performance iss