Nov 2019 Citus Newsletter (now part of Microsoft)

Citus now GA on Microsoft Azure

As of early November, Citus is now generally available as a built-in deployment option in Azure Database for PostgreSQL. Hyperscale (Citus) transforms your Postgres database into a database that you can not only scale up and down, but also scale out horizontally.
Read Craig’s blog →

Rob Conery’s post: Virtual, Computed Columns in PostgreSQL 12

Rob Conery is extremely excited about one of the new features in PostgreSQL 12: Generated (or computed) columns. Generated columns are special columns that are always computed from other columns. Thus, generated columns are for columns what a view is for tables. In his article, Rob runs through an example, from high-level down to the weeds, on how to use generated columns.
More on generated columns →

Latest updates on Azure and Postgres at Ignite 2019

At the Ignite conference in Orlando earlier this month, our Postgres team announced several new Azure Postgres features (like more storage) and new regions, in addition to announcing the GA of Hyperscale (Citus) on Azure. Sudhakar Sannakkayala tells us all about it.
New stuff for Azure Database for Postgres →

Come say hello at PgDay San Francisco

On January 21, 2020, the magic of the 1-day, single-track Postgres community event comes to San Francisco. Our Postgres team Microsoft is a big fan of these 1-day “PgDay” events that pack so much useful information & so many Postgres people in one place for a whole day. So we’ve joined a growing list of companies to support the community event, and we will be a premiere sponsor; we also signed up to sponsor the live captioning (because, accessibility). The CFP just closed with 10 proposals for every slot, so you know the sessions are going to be great.
Get your ticket now →

List PostgreSQL tables using extensions

Dimitri Fontaine, author of The Art of Postgres and an engineer on our Postgres team at Microsoft—also the author of CREATE EXTENSION—shows a query you can use to list tables in your schemas that are using a data type which is provided by an extension.
More in Dimitri’s post →

Architecting petabyte-scale analytics by scaling out Postgres on Azure with the Citus extension

Claire Giordano sat down with engineer Min Wei of Microsoft to find out how the Windows team assesses the quality of new software builds, to decide if the next software update is ready to ship. The part of the answer we love best is that Min’s team scales out Postgres on Azure—using Citus—to power a 1.5 petabyte (and growing) analytics dashboard, analyzing 20K types of metrics from over 800M Windows devices. Read on to find out what Claire learned.
Read about Min Wei’s architecture →

Database constraints in Postgres: The last line of defense

Constraints are an extremely powerful construct for your database. And when it comes to your database, constraints are the last line of defense. Inspired by his popular talk, Will Leinweber explains how constraints are essentially rules that your data has to follow.
Get Will’s take on database constraints →

Tell us your Citus story

Our friends at Deversity recently told their Citus story in a blog post, and we hand-delivered their hoodies at PGConf EU, as a way of saying thank you. :-) Do you have a story on how the Citus extension to Postgres helped you with your app performance & scale? We’d love to hear more. Share your Citus story with us, and as a thank-you we’ll send you a super-soft Elicorn hoodie—just in time for hoodie season.
We can’t wait to hear your story! →

Join our public Slack channel

DYK we have a public Slack channel for the Citus community? It gives you direct access to our engineers, customers, users, and community members—to help you when you need it.
Join us! →

ICYMI: Auto Failover with PostgreSQL 12

PostgreSQL 12 was announced just last month, and pg_auto_failover 1.0.5 has released with Postgres 12 compatibility, and already published their packages. In this post, Dimitri explains what pg_auto_failover is, and the changes that were needed for Postgres 12 compatibility.
Read Dimitri’s post →

Videos of some recent Postgres talks for your viewing pleasure:

Is Citus right for you?

Want to explore whether Citus is right for you and your use case? Learn more about the Citus product, check out the documentation, or watch this short demo of Hyperscale (Citus) on Azure Database for PostgreSQL.