#​411 — June 23, 2021

Web Version

Postgres Weekly

Better Range Types in Postgres 14: Turning 100 Lines of SQL Into 3 — I’m always going to take fewer lines of code rather than more, so I was won over by the title alone. It turns out the forthcoming Postgres 14 adds support for multi range types which provides extra power to some pure SQL solutions.. an example of which is provided here.

Jonathan S. Katz

How (and Why) to Become a Postgres Contributor — A “collection of advice” to help anyone keen to make the jump from having never contributed to contributing just a little. The keys are to learn about the development process, setting up a dev environment for Postgres on your local machine, and biting off something very small.

Aleksander Alekseev

Build Internal Apps (Faster) on Top of Postgres — Build internal apps without the mundane, boring bits (wrestling w/ UI libraries or hacking together data sources & APIs).

Retool sponsor


  • A quick Twitter thread on how a developer sped up his slowest queries by 'over 100x' after a migration from Firebase to Postgres.

  • pgCenter 0.9.0 has been released. pgCenter is a command line tool for observing and troubleshooting Postgres, written in Go.

A New Kind of Database: Combining Postgres and Citus Tables — Citus is commonly used to make Postgres more distributed and scalable but you still get to enjoy all of Postgres’s usual features and even blend them together. This post digs into Citus 10’s support for foreign keys between local Postgres tables and Citus reference tables.

Onur Tirtir (Citus Data)

From MD5 to SCRAM-SHA-256 — Postgres 10 and beyond support the scram-sha-256 mechanism for password hashing and authentication, although you might well still be using MD5. This post touches on the benefits and approach to switching.

Laurenz Albe

Talking about the Postgres Optimizer at CMU — Last week we featured Robert Haas’s recent talk about Postgres’s query optimizer but he’s written up some notes on particular parts of the talk if you didn’t have to time to watch it all.

Robert Haas

▶️ Creating Sample Postgres Data: What Are Your Options?Watch this short how-to video series for 4 ways to generate realistic sample data for benchmarking, demos & beyond 🚀

Timescale sponsor

Zero-Downtime 'Schema Migrations' in Postgres using Views — It’s not exactly a classical sort of migration but.. it's an interesting line of thought.

Fabian Lindfors

Logging Tips for Postgres, Featuring Your Slow Queries — A look at a useful log-related setting (log_min_duration_statement) to help identify performance issues. A lot of the post is about Crunchy and LogDNA, though, so you may prefer the logging settings docs.

Kat Batuigas

pg_notify_exporter: A Listen/Notify Exporter for Prometheus — Uses LISTEN/NOTIFY to export to Prometheus events triggered in table operations (INSERT, UPDATE and DELETE).