3 ms·
Aggregate push down to foreign servers seems to overlap with Citus. It's not as transparent, but you could have a dataset sharded across several PG instances,
by bjt 9y ago
Aggregate push down to foreign servers seems to overlap with Citus. It's not as transparent, but you could have a dataset sharded across several PG instances, mount them all into a master with foreign data wrappers, and UNION them (for some queries) to aggregate across the set.
- amitlan 9y agoBTW, you can also create partitions as foreign tables: https://www.postgresql.org/docs/10.0/static/sql-createforeigntable.html https://www.postgresql.org/docs/10.0/static/sql-createforeig...