Jul 2021 Citus Open Source Newsletter

How Citus Distributes PostgreSQL—a video

Rumor has it, this is the best overview of Citus ever. Marco Slot, the Citus technical lead, explains how Citus works, what you need to know about the new table types Citus introduces (distributed tables and reference tables), what the distributed query planner does, & how Citus handles distributed database transactions. Not to be missed.

Watch the video ⟶

Citus Tips: JOINs between local & distributed Postgres tables

As of Citus 10, you can do JOINs between local Postgres tables and distributed Citus tables. Along with new foreign key support between local tables and reference tables, you can now mix local and distributed tables to get the best of both worlds, without having to separate them in your data model.

Read Talha’s post ⟶

Citus 10.1 is out!

Citus 10.1 builds on all the transformative capabilities in Citus 10 to make your life even easier, bringing improvements to the shard rebalancer as well as performance improvements, including multi-row inserts. Blog post coming soon.

Read the changelog ⟶

New ways to get started with Azure Database for PostgreSQL

In this crisp 20-minute edition of Azure Friday, Claire Giordano introduces Scott Hanselman (and you) to not only running Postgres on Azure but how easy it is to get started—ft. Hyperscale (Citus).

Watch the show ⟶

Hello pg_auto_failover v1.6.1

With this release, you can now build pg_auto_failover with Postgres 14. Other key additions include new “dropped” state in the FSM, feature crash recovery before pg_rewind, & drop-at-a-distance semantics. Lots of changes & bug fixes too.

Read the changelog ⟶

Oracle to Postgres Migration Guide

Hot off the press, the Oracle to Postgres Migration Guide is updated to provide you with snackable information to help you migrate Oracle workloads to Postgres. Arun has written a couple helpful posts too: one focused on the migration process, and another starring the migration of storage objects.

Read the guide ⟶

Hasura Cloud now supports Citus

Hasura Cloud gives you a fully managed, production ready GraphQL API as a service to help you build modern apps faster. Now, you can get started with Hasura on Citus in just 30 seconds!

Read the announcement ⟶

Manage Flexible Server with the Azure Databases extension for VS Code

The Azure Databases extension for VS Code (Preview) can now manage Azure Database for PostgreSQL - Flexible Server. You can provision new instances straight from VS Code and pick the configuration you need (including the basic/free tier).

Check out Anthony Shaw’s tweet ⟶

Ebiquity reduces data query times by 98% with Azure Database for PostgreSQL

Ebiquity, a world leader in media investment analysis, wanted to gain scalability for the future. With Flexible Server, Ebiquity not only scales workloads without compromising performance, but also identifies 15-50% wastage in their customers’ advertising spending, allowing their customers to allocate funds elsewhere. Wow!

Read the story ⟶

Create cloud native apps with Azure and open-source software

This hands-on learning path covers the essentials of selecting components for cloud-native apps, building the integrations, and deploying to Azure. You’ll create multiple and varied services step by step.

Explore the learning path ⟶

ICYMI: A new kind of database: Combining Postgres & Citus tables, feat. foreign keys

Learn how to use foreign keys in Citus between local Postgres tables and reference tables, so you can adopt hybrid local-distributed data models. Now, you can distribute some of your Postgres tables with Citus, while leaving some tables as local to the coordinator—even when you’re using foreign keys.

Read Onur’s post ⟶