| 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.1 Released! |
| Date: | 2023-10-06 18:43:16 |
| Message-ID: | 169661779695.657.41299884115617703@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce |
## PostgreSQL 16 supported on Citus
Citus 12.1 adds support for Postgres 16. There are many new features that are enabled by PG16 that are particularly interesting for Citus users:
* Load balancing when querying from any node
* pg_stat_io in a distributed Citus cluster
* Support for JSON_ARRAYAGG() and JSON_OBJECTAGG() aggregates
* Support for DEFAULT option to COPY FROM
* Propagate custom ICU collation rules
* Support for TRUNCATE triggers on Citus foreign tables
* Propagate new CREATE TABLE, VACUUM, and ANALYZE options to Citus nodes
In addition to support of Postgres 16 Citus 12.1 also includes:
* GRANT CREATE ON DATABASE
* Distributed schema move with citus_schema_move ()
## Where to find the Citus 12.1 Blog post, Release Notes, & Release Party Livestream
* __Citus 12.1 blog post__: Read [Naisila’s 12.1 post](https://www.citusdata.com/blog/2023/09/22/adding-postgres-16-support-to-citus-12-1/) for more insight on the new features and improvement in Citus 12
* __Release notes__: Get all the nitty gritty details on the [Citus 12.1 updates page](https://www.citusdata.com/updates/v12-1/).
* __Watch the Citus 12.1 release party__: [The release party](https://www.youtube.com/live/TsHs9x9ILMg)—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 | Red Hat via PostgreSQL Announce | 2023-10-06 18:53:54 | pgmoneta 0.7.0 |
| Previous Message | Toshiba via PostgreSQL Announce | 2023-09-28 21:15:23 | SQLite FDW 2.4.0 released |