Schema-based sharding for PostgreSQL

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

Release notes: Get all the nitty gritty details on the Citus 12.0 updates page.

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