From: | Citus Data via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
Subject: | Citus 12.0 released! |
Date: | 2023-08-09 08:43:17 |
Message-ID: | 169157059704.631.6272052507642112424@wrigleys.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
## 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](https://www.citusdata.com/blog/2023/07/18/citus-12-schema-based-sharding-for-postgres/) 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](https://www.citusdata.com/updates/v12-0/).
__Watch the Citus 12 release party__: [The release party](https://www.youtube.com/live/_3UPL-EVwKA)—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](https://youtu.be/JwjjUT8K7po). With Citus, you can create tables that are transparently distributed or replicated across a cluster of PostgreSQL nodes. Citus is available as [open source](https://www.citusdata.com/download/) and also as a [managed service on Azure](https://aka.ms/docs-citus-on-azure)
From | Date | Subject | |
---|---|---|---|
Next Message | PostgreSQL Global Development Group | 2023-08-10 12:51:24 | PostgreSQL 15.4, 14.9, 13.12, 12.16, 11.21, and PostgreSQL 16 Beta 3 Released! |
Previous Message | PL/R via PostgreSQL Announce | 2023-08-08 15:34:34 | PL/R 8.4.6 released |