Jul 2022 Citus Open Source Newsletter

Monitor distributed PG activity with new views in Citus 11

How to observe a distributed Citus cluster from any node with the new Citus 11 features: citus stat activity, citus lock waits, & the new global process ID.

Read Ozan’s post ⟶

Debugging Postgres autovacuum problems: 13 tips

Hot off the press! If you’ve run into problems with autovacuum (not triggering enough? too slow? not cleaning up dead rows?) then this blog post and cheat sheet of 13 tips will likely be useful.

Read Samay’s post ⟶

Citus 11 release notes

Want to know all the Citus 11 details? The new Updates page has them all. And not just for Citus 11—there are updates pages all the way back to Citus v9.2.

Check out the new Citus 11 release notes ⟶

Query Citus on Azure from your app stack

Want to query Citus on Azure using Python, Node JS, C#, Java, or Ruby? There’s a how-to guide for each of these languages.

Read the Azure docs ⟶

Video: 18 ways to contribute to Postgres

At Citus Con, Claire gave an updated version of her kickoff talk from FOSDEM, about 18 ways you can contribute to Postgres—beyond code. Includes tips and examples.

Watch Claire’s talk ⟶

Magnus Hagander presents: PostgreSQL—more relevant than ever

In this video of his keynote from Citus Con, Magnus Hagander of the Postgres core team shares his take on why & how PostgreSQL is more relevant than ever.

Watch Magnus’s Citus Con keynote ⟶

Show your open source love with a GitHub Star

If you are a +1 about the recent Citus 11 open source news, please feel free to star the repo on GitHub. :)

Star Citus on GitHub ⟶

COVID-19 dashboard team (our customer!) wins award

The COVID-19 dashboard team has won the award for Statistical Excellence in Trustworthiness, Quality & Value from the Royal Statistical Society. Congrats! Seems like a good time to share the post Claire co-authored with Pouria Hadjibagheri, technical lead of the COVID-19 dashboard team.

Read the blog post ⟶

Video: Queues in Postgres

Many projects involve job or message queues. Thomas is not only an expert PG developer; he’s also an engaging presenter. You’ll have fun watching this!

Watch Thomas’s #CitusCon talk ⟶

ICYMI: Citus 11—now with query from any node

Citus 11 is out! It’s 100% open source, and you can query from any node. Read all about it in Marco’s release blog. (Or watch the demos in the release party.)

Read Marco’s post ⟶