Mar 2021 Citus Newsletter (now part of Microsoft)

Citus 10 is out!

Citus 10 is our most spectacular open source release yet. Marco's post gives an overview of columnar for Postgres, the open source shard rebalancer, Citus on a single node, & so much more.

Read Marco's post ⟶

Columnar compression comes to Citus

Citus 10 brings columnar to Postgres. This post includes a quickstart and link to the Citus 10 Columnar demo. Plus, row vs. columnar comparisons for data loading, compression ratios, & query response times.

Read Jeff's post ⟶

Shard rebalancer = open source

Big news: in Citus 10, we open sourced the shard rebalancer. Learn how it works, how to use it, and your options for different rebalancing strategies.

Read Jelte's post ⟶

Citus on a single node, wait what?

With Citus 10, you can now shard Postgres on a single node. Onder explains when you might want to do this, and what it means to distribute your tables on a single Citus node.

Read Onder's post ⟶

PG 14 stories: Speeding up recovery & VACUUM

A "how we did it" post. All about Postgres committer David Rowley's performance engineering efforts to make recovery and vacuum faster in PostgreSQL 14.

Read David's post ⟶

Video demo of Citus 10 Columnar

Learn how to use the new Citus 10 columnar feature for Postgres to achieve 3x-10x compression ratios, reduce IOPs, & deliver faster query responses.

Watch Jeff's demo ⟶

Run docker run

Because of the new single-node Citus feature introduced in Citus 10, it's easier than ever to try Citus. After installing Docker, you can now start Citus with just a single docker run command.

Give Citus a try ⟶

PostgreSQL accepted for GSoC 2021

Not-surprising but good to hear anyway: the PostgreSQL open source project has been accepted to participate in the Google Summer of Code program. For the 14th time.

Read the announcement ⟶

Hello to pg_auto_failover v1.5.1

Just last week Dimitri Fontaine tweeted that pg_auto_failover 1.5.1 is out. And the updated documentation now includes man pages for all commands.

Read the changelog ⟶

New table & shard views in Citus 10

If you've ever wanted a human-readable table view into all your Citus tables (how meta) or all the low-level shard metadata, these new Citus doc pages should make you happy.

Read the docs ⟶

The first Citus 10 talk at a meetup

If you missed the Citus 10 talk and demo at the contributing.today open source meetup a few weeks ago, not to worry. Claire’s and Nils’s slides are on speakerdeck, and there's a video, too.

Watch the video ⟶

ICYMI: Faster Postgres data migrations

Tips for migrating from one Postgres database to another. Covers pg_dump, pg_restore, and Parallel Loader.

Read Sai's post ⟶