PostgreSQL 17 supported on Citus

Citus 13.0 adds support for Postgres 17. There are many new features that are enabled by PG17 that are particularly interesting for Citus users:

• JSON_TABLE() support in distributed queries
• Propagate "MERGE ... WHEN NOT MATCHED BY SOURCE" syntax
• Expanded functionality on distributed partitioned tables
• Propagate new EXPLAIN options: MEMORY and SERIALIZE
• Optimizer improvements

In addition to support of Postgres 17 Citus 13.0 also includes:

• Bug fixes that address some crashes caused by unsafe catalog access, and segmentation faults in distributed procedures
• Fixes to resolve issues related to role synchronization across nodes, server crashes in specific cluster configurations, and improve handling of shard placement when new nodes are introduced without required reference data

Where to find the Citus 13.0 Blog post, Release Notes, & Release Party Livestream

• Citus 13.0 blog post: Read Naisila’s 13.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 13.0 updates page.

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