The PostgreSQL community debates ALTER SYSTEM [LWN.net] lwn.net - get the latest breaking news, showbiz & celebrity photos, sport news & rumours, viral videos and top stories from lwn.net Daily Mail and Mail on Sunday newspapers.
Scaling out Postgres with the Citus open source shard rebalancer Written by
Get our monthly newsletter
One of the main reasons people use the Citus extension for Postgres is to distribute the data in Postgres tables across multiple nodes. Citus does this by splitting the original Postgres table into multiple smaller tables and putting these smaller tables on different nodes. The process of splitting bigger tables into smaller ones is called sharding and these smaller Postgres tables are called “shards”. Citus then allows you to query the shards as if they were still a single Postgres table.
One of the big changes in Citus 10 in addition to adding columnar storage, and the new ability to shard Postgres on a single Citus node is that we open sourced the shard rebalancer.