4 ms·
Citus is building functionality on PostgreSQL to provide sharding for data sets too large for a single machine. There aren't really any PG 10 features that dupl
by dhd415 9y ago
Citus is building functionality on PostgreSQL to provide sharding for data sets too large for a single machine. There aren't really any PG 10 features that duplicate that. Some of the new PG features such as increased query parallelism allow for better utilization of single-machine resources. Other features such as logical replication may allow for some horizontal scaling by splitting read workloads across replicas, but none of them provide any sharding capabilities.
- bjt 9y agoAggregate 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...
- qeternity 9y agoMany of them seem like pre-requisites however. I understand what Citus does vs Postgres. But that gap is narrowing.