Citus 12.1 Released!

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 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.

• Watch the Citus 12.1 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