Though, I imagine there's a region in the data size/network throughput/latency space where simply fetching the data and then doing analytics in ClickHouse is more performant than actually going for the pushdown.[3]
[1] https://www.splitgraph.com/blog/postgresql-fdw-aggregation-p... [2] https://www.splitgraph.com/blog/postgresql-fdw-aggregation-p... [3] https://duckdb.org/2022/09/30/postgres-scanner.html