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