[mosselman]

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?

[manigandham]

No. 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).

[giancarlostoro]

All I found was this:

https://wiki.postgresql.org/wiki/Replication,_Clustering,_an...

And Citus is the first link in that list.

[riku_iki]

Citus 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.