pg_flame: A Flamegraph Generator for EXPLAIN ANALYZE's Output — Reads a JSON query plan from stdin and writes the HTML for the flamegraph HTML to stdout. Available to use via Docker, if you want to keep things simple.

Marcus Gartner

Postgres 12.2, 11.7, 10.12, 9.6.17, 9.5.21, and 9.4.26 Released — A true smorgasbord of versions here, with basically every major production of Postgres getting an update to fix a critical security issue, as well as variety of minor bug fixes. This is also Postgres 9.4’s last release with 9.4 now at its “end of life”.

PostgreSQL Global Development Group

Monitor Custom Postgres Metrics in Real-Time with Datadog — Monitor and visualize Postgres performance in context end-to-end alongside the rest of your stack. Create custom, drag-and-drop dashboards to quickly view analytics on any Postgres metric. Try Datadog free.

Datadog sponsor

Isolation Repeatable Reads in Postgres vs MySQL — By default, Postgres and MySQL use different levels of isolation within transactions. Within a running transaction, Postgres will see changes made by other transactions once committed, whereas MySQL uses “repeatable read” where the results of a query remain consistent throughout a transaction. There’s a bit more to it than that, though, and this post deftly shows us how it all works.

Daniel Vérité

An Experience of Migrating to CockroachDB from Postgres — We love Postgres, but we love a story even more, so it’s interesting to hear about the experiences this engineer had when shifting from Postgres to CockroachDB (for the reason of better “out of the box support for high availability”).

Karl Seguin

Useless Vacuuming — What can you do when autovacuum seems to be running fine, but there are still vacuum related problems? Robert explains such a situation and how to resolve it.

Robert Haas

Take Advantage of pg_settings When Dealing with Your Config — Just looking at your config files or assuming you know what the default settings are is risky. The pg_settings view gives you an authoritative view of what’s going on.

Luca Ferrari

The Why and How of Compressing WAL Archives — Why the compression of WAL archives is becoming more important, and how to do it.

Jobin Augustine

Postgres Vision 2020 - Get Your Early Bird Tickets — The leading Postgres conference will be back in Boston this year from June 22-24. Get a 2-day conference pass for $199.

EnterpriseDB sponsor

cloudfs_fdw: A Foreign Data Wrapper for Accessing Files on Cloud Filesystems — Specifically, it handles CSV, JSON, Excel and ODF files on S3 or over HTTP(s).

Ernst-Georg Schmid

Schemalint: A Linter for Postgres Schemas — A linter that lets you raise errors on issues like casing or column types (so think more like ESLint than a basic formatter).

Kristian Dupont

wal2json: A JSON Output Plugin for Changeset Extraction — A JSON object is produced per transaction (or tuple) containing both the new and old tuples for updates.

Euler Taveira de Oliveira