3 ms·
Can anyone shed some light on how the supposed new cluster features of Postgres 10 compare to something like Citus? In other words. Does Postgres 10 offer the
by mosselman 9y ago
Can anyone shed some light on how the supposed new cluster features of Postgres 10 compare to something like Citus?
In other words. Does Postgres 10 offer the same features in terms of clustering as Citus does?
- riku_iki 9y agoCitus provides ability to build sharded environment. Data for different customers can be stored on separate nodes, and your DB is not limited by capacity of one node. In regular PG, all data need to fit single node.
- giancarlostoro 9y agoAll I found was this: https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling#Clustering https://wiki.postgresql.org/wiki/Replication,_Clustering,_an... And Citus is the first link in that list.
- manigandham 9y agoNo. Postgresql is a single-node database. It supports replication and failover to other nodes and foreign-data-wrapper extensions that let it query other datasources, but it does not have any support for natively working as a distributed database across several nodes. Citus is an extension that takes several database nodes and makes them appear as a single logical database server (at the table level, by automatically sharding them based on a column).