
Sneak preview of sharding on a single Citus nodeĬitus 9.5 racecar graphic features Postgres 13 support and of course has a decal of our open source mascot, the Citus Elicorn Hello to Postgres 13! Citus 9.5 now supports Postgres 11, 12, and Postgres 13Ĭitus 9.5 is the first version of Citus to come out after the Postgres 13 release.

#POSTGRES 14 SHARDING CODE#
Refactoring removal of over 7k lines of code.Quality improvements by chasing down exotic database bugs.EXPLAIN ANALYZE now shows the slowest task.Load balancing for stored procedure calls on reference tables.Function to change distributed table to a local table.Adaptive connection management for COPY.If you like bullets, there is a much longer bulleted list of 47 fixes and improvements in the CHANGELOG for Citus v9.5.0 in the Citus open source GitHub repo.Ī high-level overview of what’s new in Citus 9.5 encompasses these 8 buckets: What’s new in Citus 9.5, the bullet story Citus is available as open source, as on-prem enterprise software, and in the cloud as Hyperscale (Citus), a built-in deployment option for the managed Postgres database service on Azure. Side-note: If you’re new to Citus and are wondering what it is, the short answer is that Citus is an extension to Postgres that transforms Postgres into a distributed database-distributing your data and your queries across multiple nodes.

Now it’s time to walk through everything new in the Citus 9.5 open source release.

Since FOSDEM, Marco Slot and I have blogged about how Citus 9.2 speeds up large-scale htap workloads on Postgres, the Citus 9.3 release notes, and what’s new in Citus 9.4. When I gave the kickoff talk in the Postgres devroom at FOSDEM this year, one of the Q&A questions was: “what’s happening with the Citus open source extension to Postgres?” The answer is, a lot.
