Citus 12 adds a new and easy way to scale your Postgres database—schema-based sharding. Unlike row-based sharding, where tables are distributed based on the value in the distribution column, schema-based sharding transparently shards your database by schema name. This new model enables new workloads, that were either hard or impossible to achieve with row-based sharding, most notably microservices and non-homogenous per tenant schemas. So now, you may have a choice based upon the needs of your application—row-based sharding or schema-based sharding.
In addition to schema-based sharding Citus 12 also includes:
Sampling in tenant monitoring which improves performance
A change to the default rebalancing strategy which is now "by_disk_size"
Improved MERGE support
Where to find the Citus 12.0 Blog post, Release Notes, & Release Party Livestream
Citus 12 blog post: Read Marco’s 12.0 post for more insight on the new features and improvement in Citus 12
Watch the Citus 12 release party: The release party—including demos and Q&A—is available to watch on YouTube.
About the Citus database extension
Citus is a distributed database built entirely as an open source extension for PostgreSQL. With Citus, you can create tables that are transparently distributed or replicated across a cluster of PostgreSQL nodes. Citus is available as open source and also as a managed service on Azure
