Citus Newsletter

Citus 9.2 speeds up HTAP workloads on Postgres ⟶

Latest from our dev team about Citus 9.2 open source. All about performance improvements for HTAP (hybrid transactional & analytic processing) including CTEs, aggregate functions, & re-partition joins.

Marco Slot

Q&A with PostgreSQL committers joining our team ⟶

To welcome Thomas Munro, Jeff Davis, & Andres Freund to our team, we put together this Q&A about open source, how Postgres is changing, impressions of Postgres on Azure, & use cases that Postgres serves.

Ozgun Erdogan & Sudhakar Sannakkayala

How to configure Postgres log settings ⟶

All about understanding Postgres log parameters, so you have enough logs to be aware of & diagnose issues, but not so many that they drag down your Postgres server's performance.

Rachel Agyemang

A simpler way to sign in to Azure Database for PostgreSQL ⟶

No password required. You can now seamlessly sign-in to your Postgres database on Azure without specifying a password, just by selecting your AD account.

Lukas Fittl

Have you read A Curious Moon, a data science mystery ft. Postgres & Cassini? ⟶

If you're sheltering at home, this ebook might help pass the time. It's a holistic approach to learning Postgres: you won’t just learn SQL, you'll learn what it means to sling data for a living. Thank you to Rob for creating this PostgreSQL tutorial in the spirit of The Martian.

Rob Conery

ICYMI: How to use QGIS & PostGIS with Azure Database for PostgreSQL ⟶

Last month's guest post is all about how to use open source desktop GIS software (QGIS) for visualization and analysis of spatial data—in combination with Azure Database for PostgreSQL & PostGIS.

Topi Tjukanov

Using Hibernate & Spring to build multi-tenant Java apps ⟶

Customers tell us this multi-tenancy 'how-to' is as useful today as the day it was written. Using Hibernate as your Java ORM, you can build multi-tenant apps with Postgres.

Joe Kutner

Short 15-min video interview on why Azure for Postgres ⟶

This interview with Umur Cubukcu shows us why Umur loves Postgres—and why he thinks Azure can be the best destination for Postgres.

Umur Cubukcu & Sanjay Soni

Have you joined the Citus public Slack? ⟶

Our public Slack channel is full of useful Q&A about the Citus extension to Postgres—with Citus engineers, open source users, & customers all participating. Join us.

Citus team on Slack

Taking Postgres's temperature with these 4 system metrics ⟶

Monitoring, troubleshooting, bloat

Virtual, Computed Columns in PostgreSQL 12 ⟶

JSONB, generated columns, concat

Auto Failover with PostgreSQL 12 ⟶

HA, open source

Video of Marco's talk at dotScale Paris on scaling out Postgre(SQL) ⟶

Distributing SQL queries, Citus

Quickstart for creating a Hyperscale (Citus) database cluster on Azure ⟶

Docs, Citus, Hyperscale, Azure Database for PostgreSQL

Lætitia Avrot's daughter puts crafting to work with Postgres ⟶

Pins, kids, crafts, Postgres

Alicja's slides from PyData Berlin virtual meetup ⟶

PyData Berlin has gone virtual; here are slides from Alicja Kucharczyk's recent talk on architecting petabyte-scale analytics with Postgres.

Video of Dimitri's talk last year at pgDay Paris ⟶

In honor of pgDay Paris (cancelled due to COVID), we give you this video of Dimitri Fontaine's talk about how to write SQL queries.

Claire's FOSDEM slides: 21 ways to contribute to Postgres ⟶

There are many ways to contribute to Postgres, from code and beyond.

PGCon 2020 is going virtual ⟶

So many events have been cancelled due to COVID, to help flatten the curve. We are grateful that PGCon will be going virtual. Stay tuned for details.

PyCon 2020 also cancelled & is planning online options ⟶

We love PyCon and are really going to miss it this year. We hear that virtual PyCon content is getting created—stay tuned.