Using the Postgres HyperLogLog Extension — HyperLogLog is a way to efficiently approximating cardinality and Citus Data offers a Postgres extension for bringing HyperLogLog functions into Postgres.

Wisdom Devs

Introducing Automated Postgres EXPLAIN Plan Insights on pganalyze — pganalyze now can automatically collect EXPLAIN plans and provide a visual representation of your costliest plan nodes and more helpful insights into your Postgres database. Learn more about all new EXPLAIN plan features in this blog post.

pganalyze sponsor

The Curious Case of the Table-Locking UPDATE Query — “Your database has locks (think mutexes but with varying scope), and those locks can mess up your day if they’re doing something different than you’re expecting.”

Richard Schneeman

Amazon RDS User? Time to Rotate Your Certificates — Every five years, the certificates used by AWS RDS, Aurora and DocumentDB expire and are replaced with new ones, so if you’re using SSL/TLS connections or certificate validation, you may have some work to do before March 5, 2020.

Jeff Barr (AWS)

The Top Postgres Links of 2019 — Postgres highlights from the past twelve months, as clicked on by readers of Postgres Weekly.

Za'e Johnson

Why You Might Need to Increase max_locks_per_transaction — If you’ve ever seen the “out of shared memory” error, this is a parameter you might want to consider tweaking.

Hans-Jürgen Schönig

One Developer's 'Go To' Postgres Configuration for Web Services — This is essentially a developer jotting down all of his notes for setting up Postgres, but.. I like posts like that because there’s often a tip or two to pick up :-)

Peter Bui

How to Effectively Dump Postgres Databases — Some useful notes and scripting around pg_dumpall and pg_dump.

Hubert depesz Lubaczewski

Setting Postgres's Configuration Parameters — Tweaking things in postgresql.conf is one thing but there are other options that are relevant, including changing certain settings on a user or session level.

Hans-Jürgen Schönig

recovery.conf is Gone in Postgres 12 — In Postgres 12, recovery.conf’s settings have been ‘absorbed’ into postgresql.conf – here’s more on the changes and how to handle it for yourself.

Laurenz Albe

Automate Your Postgres & TimescaleDB Schema Design — Built by the team at Timescale, PGSchema is an easy-to-use tool that generates your SQL schema in 3 simple steps: upload, format, copy.

Timescale sponsor

RDS's Price Premium over EC2 Can Be More Than You'd Expect — RDS is Amazon’s Relational Database Service which can provide a fully managed Postgres (or MySQL, Oracle, and others) service on AWS. The increasing price premium of RDS over EC2, however, surprised this developer.

Rick Branson

Message DB: An Event Store and Message Store for Postgres — Aimed at pub/sub, event sourcing and evented microservices use cases, Message DB can help you take advantage of the benefits of evented architecture but without going all the way to something like Apache Kafka.

Eventide Project

Postgres.js: A Fast, Full-Featured Postgres Client for Node.js — Claims to be the fastest even (at 2-10x faster than the popular pg module) but we’ll let you be the judge of that :-)

Rasmus Porsager