#304 — May 8, 2019

Read on the Web

Postgres Weekly

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.


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


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

🏖 Do you have a tip of the week for us?

The Postgres Tip of the Week is taking a brief vacation this week, but will be back next week. If you have any suggestions or tips to submit, we're open to submissions here and we pay up to $100 for any tip we use :-)

🗓 Upcoming Postgres Events

  • PGDay.IT 2019 (May 16-17 in Bologna, Italy)
  • PGDay Belgium 2019 (May 17 in Leuven, Belgium) — Registration has just opened.
  • PGCon 2019 (May 28-31 in Ottawa, Canada) — An annual conference for users and developers to meet and discuss all things Postgres.
  • PostgreSQL Ibiza (Jun 19-21 on Ibiza) — This Postgres conference taking place on Spain's famous party island promises you both "Postgres on the beach" while still having talks and training in a pretty neat looking venue.
  • Postgres Vision 2019 (June 24-26 in Boston, MA)