#​438 — January 19, 2022

Web Version

Postgres Weekly

Five Easy to Miss Postgres Query Performance Bottlenecks — Postgres’s query planner usually does a fantastic job, but can sometimes throw up the odd surprise or weird strategy, so the common-sensical or obvious query you wrote might not always go to plan! This post presents a valuable look at optimizing such seemingly obvious queries with the help of EXPLAIN ANALYZE and metadata analysis.

Paweł Urbanek

More SQL, Less Code, with PostgreSQL — There are numerous schools of thought on how much work a database system should be doing in contrast to the apps querying it. This post shows off some practical SQL-based ways you can lean towards having Postgres pick up more of the little jobs that your app may currently be handling.


Transparent Data Encryption: Encrypting Your Entire Database — TDE is a CYBERTEC patch to PostgreSQL. It is currently the only implementation that supports transparent and cryptographically safe data (cluster) level encryption, independent of operating system or file system encryption.

CYBERTEC sponsor

On Progress Bars for Postgres Queries.. Let's Dive Deeper — Last week we featured a fun post about monitoring the progress of long running queries, and this post digs somewhat deeper into some of the mechanisms involved and includes some recipes for practical monitoring of lengthy queries in production.

Nikolay Samokhvalov

Bi-Directional Replication using pglogical — While Postgres has native replication features now, the pglogical extension still has a few extra tricks up its sleeve including bi-directional replication.

Yaser Raja and Peter Celentano (AWS)

Why I Enjoy PostgreSQL: An Infrastructure Engineer's Perspective — Mostly it’s down to schema changes being (relatively) pleasant.

Shayon Mukherjee

In brief:

🔧 Code and Tools:

temBoard 7.9: A Postgres Remote Control/Dashboard — A Python-built Postgres Web dashboard and monitoring system. You install an agent on the Postgres servers in question and then the temBoard webapp runs wherever you want.


Identify, Track & Fix Problematic Tests with Buildkite’s Test Analytics ✅

Buildkite sponsor

Redix: A Fast Persistent Pure Key/Value Store — A key value store that speaks the Redis protocol but uses Postgres as its storage engine. First unveiled three years ago as a learning experience, this has been frequently updated and turned into a neat project - written in Go.

Mohammed Al Ashaal