Naisila Puka

Naisila Puka

CITUS BLOG AUTHOR PROFILE

Software Engineer on the Postgres & Citus team at Microsoft. B.S. in Computer Engineering with Mathematics minor from Bilkent University. Conference speaker at PGCon and Citus Con: An Event for Postgres. Boy mom. Language buff.

@naisilapuka naisila

PUBLISHED ARTICLES
Naisila Puka

Adding Postgres 16 support to Citus 12.1, plus schema-based sharding improvements

Written by By Naisila Puka | September 22, 2023 Sep 22, 2023

The new PostgreSQL 16 release is out, packed with exciting improvements and features—and Citus 12.1 brings them to you at scale, within just one week of the PG16 release.

As many of you likely know, Citus is an open source PostgreSQL extension that turns Postgres into a distributed database. Our team started integrating Citus with the PG16 beta and release candidates early-on, so that you could have a new Citus 12.1 release that is compatible with Postgres 16 as quickly as possible after PG16 came out.

There are a lot of good reasons to upgrade to Postgres 16—huge thanks to everyone who contributed into this Postgres release! PG16 highlights include query performance boost with more parallelism; load balancing with multiple hosts in libpq (contributed by my Citus teammate, Jelte Fennema-Nio); I/O monitoring with pg_stat_io; developer experience enhancements; finer-grained options for access control; logical replication from standby servers and other replication improvements, like using btree indexes in the absence of a primary key (contributed by one of my teammates, Onder Kalaci.)

The good news for those of you who care about distributed Postgres: Citus 12.1 is now available and adds support for Postgres 16.

In addition to Postgres 16 support, Citus 12.1 includes enhancements to schema-based sharding, which was recently added to Citus 12.0—and is super useful for multi-tenant SaaS applications.

Keep reading

Page 1 of 1