Apr 2021 Citus Newsletter (now part of Microsoft)

Citus internals: how does it work?

If you’ve always wanted to understand how Citus works, this is for you. Marco highlights 7 key moments in the video of his Carnegie Mellon talk about distributing Postgres with Citus.

Read Marco’s post ⟶

New Basic tier in Hyperscale (Citus)

The new Basic tier that is in preview in Hyperscale (Citus) makes it easy to get started with Citus on Azure—and easy to shard Postgres even when your workload is small. And the cost is so much more affordable, Hyperscale (Citus) Basic tier in US East starts at $0.27 USD/hour.

Read Onder’s post ⟶

Citus interview on Hello World

If you only have 5 minutes to learn what Citus is, our friend Aaron recently interviewed Citus engine lead Marco Slot on the OSS Spotlight on Hello World. Aaron put together some useful Postgres & Citus resources, too.

Watch Marco for 5 min ⟶

Why are SQL jokes the funniest?

Because you can always EXPLAIN them! When Aaron Wislang (@as_w) was preparing to join Marco on the Hello World show to talk about Postgres, he & his friends had some puns. Thread.

Read the twitter thread ⟶

Windows team grows their petabyte Citus cluster

The Windows team uses Citus and Postgres on Azure to drive a petabyte-scale analytics dashboard. Min Wei’s use case has grown so much we had to update his customer story—from 6M queries/day to 10M queries/day, from 44 nodes to 54 nodes, from a P75 of 200ms down to 150ms. Now the P95 query response time is less than 1 sec across the board.

Read Claire's post ⟶

Citus on Azure is a thing

Yep, Citus is available in the cloud as Hyperscale (Citus), a built-in option in the Azure Database for PostgreSQL managed service. With a whole bunch of useful new features in preview.

Read the docs ⟶

Shard rebalancer, now open source

There’s lots to be happy about with the Citus shard rebalancer. It’s now open source—and in addition to the 2 built-in rebalance strategies, you can add your own custom rebalance strategy too.

Read Jelte's post ⟶

Columnar compression in Citus

If you missed the news about Citus 10 columnar compression, drink up. There’s also a video demo—and some useful a timeseries docs about using Citus columnar with Postgres partitioning.

Read Jeff's post ⟶

New goodness in Flexible Server

Our Azure teammates who work on the Flexible Server managed service for Postgres are pretty jazzed about some of the new capabilities in Flexible Server (in preview.)

Read the release notes ⟶

Single docker run command

Did you know you can now run Citus open source on a single node with just a single docker run command? New as of Citus 10.

Try single-node Citus ⟶

Revamped Citus README

As part of the Citus 10 rollout we completely revamped the way we explain Citus in our GitHub README. We’d love to know what you think!

Read the README ⟶

ICYMI: the definitive Citus 10 post

We can’t wait to see what you do with Citus 10. And if you haven’t yet read Marco’s blog post, the tl;dr is that Citus 10 gives you a spectacular set of new capabilities.

See what the fuss is about ⟶