pg_auto_failover: Automated Failover and High-availability in Postgres — A new open source extension courtesy of Microsoft’s acquisition of Citus Data. pg_auto_failover aims to provide simple, automated failover built on streaming replication, with no external dependencies.

Lukas Fittl (Microsoft)

Introducing Hyperscale (Citus) on Azure Database for PostgreSQL — Now in preview on Microsoft Azure, Hyperscale (Citus) scales out data across multiple physical nodes, with the underlying data being sharded into much smaller bits. This sort of offering is essentially the key reason Microsoft acquired Citus Data recently.

Citus Data

If Engineers Need Access, You Need strongDM — strongDM works with everything in your stack. Seriously. Any database. Any server. Every environment. Learn more.

strongDM sponsor

PostgreSQL Participating in Google Season of Docs 2019 (and Summer of Code) — Season of Docs is a new Google project to encourage technical writers and open source projects to work together towards improving their docs. The writers get paid a stipend for three months of collaboration. Postgres is also taking part in the annual Google Summer of Code too if you or anyone you know is a student.

PostgreSQL Global Development Group

TimescaleDB 1.3 Released: The Postgres-Based Time-Series SQL Database — If you’ve still not played with TimescaleDB, it’s a Postgres extension that turns Postgres into a fast time-series database. 1.3 introduces support for continuous aggregates which can calculate the results of a query in the background and materialize the results bringing it somewhat closer to PipelineDB which has focused on this sort of use case for a while.

Timescale

Contributing to Postgres — If you’re looking to contribute to Postgres, here are a few helpful tips we’ve compiled.

CITUS DATA, A MICROSOFT COMPANY sponsor

Implementing A 1-to-1 Relationship in Postgres (for Real) — Forgot those tricks with UNIQUE constraints, here’s how to do it with DEFERRABLE foreign keys.

Pavlo Golub

Using CREATE USER with Caution — Having a distinction between users and roles in Postgres is essential for good management of a database.

Hans-Jürgen Schönig

How to Use pgBackRest to Backup Postgres (and TimescaleDB)

Sebastian Insausti

How to Identify Slow Queries — We did a tip in issue 301 about this but it goes a step further showing how the pg_stat_statements extension can be used for looking at query execution statistics.

Stefan Sonnenberg-Carstens

Postgres Performance on a Raspberry Pi — OK, you’re probably not going to be using Raspberry Pis to host your production database, but as a tinkerer myself, I enjoyed seeing someone go through this exercise.

Ryan Lambert

Having Lunch with PostgreSQL, MongoDB and JSON — A comparison of JSON handling in PostgreSQL and MongoDB, ultimately favoring Postgres.

Álvaro Hernández