Partitioning in Postgres – 2022 Edition — A reflection on the shifting benefits and drawbacks of using partitioned tables in Postgres while noting that things are better now than ever before: “Progress on this feature over 5 years is downright incredible. Managing a partitioned table is 90% as easy as a normal one.”

Brandur Leach

Postgres 15 is.. Almost Here! — RC 2 dropped last week, and the final is due either tomorrow or on October 20 🤞 Lætitia reminds us of the roadmap here, but if you’d rather hear about some features, here are a few to get excited about.

Lætitia Avrot

Niftys Migrates to Crunchy Bridge from Serverless — Find out why vanilla Postgres is a more cost effective and simple way to manage your database than shiny “Postgres” compatible services. Read a customer case study on getting a better database experience with better support on Crunchy Bridge.

Crunchy Bridge sponsor

Six Findings to Rely On When Managing Postgres Indexes — Knock is a notifications platform that uses Postgres as its primary data store and they’ve shared some lessons learnt from tuning their indexes. Ultimately, it comes down to making tradeoffs between query flexibility and efficiency.

Billy Ceskavich

The Why and How of Connection Pooling with pgbouncer — “Connections are not free,” so you might use some sort of proxy or pooler like pgbouncer to manage the connection load upon your database. This post explains the basics.

Hans-Jürgen Schönig

Writing Your Own Postgres Driver (in Go) — An increasing number of non-Postgres systems are now using Postgres’s wire protocol for interoperability reasons, so why not join the fun and write your own Postgres client? This post digs into the protocol a little and provides guidance, without taking away all the fun.

Konstantin Makarov

How are MySQL and Postgres ENUMs Different? — Nick gets in early with the Halloween stories with a look at the ‘spooky internals’ of how ENUMs are handled in MySQL versus Postgres.

Nick Marino

Learn About Postgres 15 and More in Our 5mins of Postgres Video Series

pganalyze sponsor

pg_auto_failover 2.0: Extension That Manages Failover for Postgres Clusters — Say hello to Postgres 15 and Citus support.

Microsoft

SI Units for Postgres — Over 2400 units imported from GNU Units including meters, kilograms, seconds, amperes, radians, lumens, and more. Learnt about this in the author’s Postgres Person of the Week interview where he reveals how his background as a trained physicist led to this extension.

Christoph Berg

'Don’t Make Databases Available on the Public Internet' — A response to a popular article last week about how many Postgres servers aren’t using SSL. Their solution is quite specific to Tailscale (a true VPN system for your own devices) but they’ve written has written and open sourced a TLS-enforcing Postgres proxy called pgproxy to bridge between Tailscale and external Postgres servers.

Tailscale