Marco Slot: What’s new in Citus 11.3 & Postgres for multi-tenant SaaS workloads

Citus enables several different PostgreSQL use cases, but one of the most popular ones is to build scalable multi-tenant software as a service (SaaS) applications. The most common way to build a multi-tenant application on Citus is to distribute all your Postgres tables by a “tenant ID” column. That way rows are (hash-)distributed across nodes, while rows with the same tenant ID value are co-located on the same node for fast local joins, transactions, and foreign keys. For those of you who build SaaS apps, one question many of you have is how active your tenants are. More specifically: What are your busiest tenants? How many queries is your application doing on behalf of your tenants, and how much CPU do those queries use? The new 11.3 release to the open source Citus database extension gives you tenant monitoring—with instant visibility into your top tenants using the new citus_stat_tenants feature, which shows query counts and CPU usage over a configurable time period. Citus 11.3 also makes many other improvements, some of which lay the groundwork for future multi-tenant SaaS capabilities too! Let’s dive in to explore these new 11.3 features: Tenant monitoring with citus_stat_tenants More reliable metadata synchronization for very large numbers of tables Parallel shard rebalancing across co-location groups MERGE support for co-located distributed tables Logical decoding (aka CDC, in preview) for Citus tables Details in the Release Notes: If you want to know the full details of the changes in Citus 11.3, check out the 11.3 Updates page for the detailed release notes. Demos in the Release Party Livestream: Mark your calendar for the Release Party if you want to see live demos of some of the new Citus 11.3 capabilities. The livestream of the Citus 11.3 Release Party will include 3 live engineering demos and is scheduled for Monday May 15 @ 9:00am PDT = 12noon EDT = 6:00pm CEST. Everything happens in the Citus GitHub repo: You can file i[...]