Postgres Weekly Issue 613: August 28, 2025

#613 — August 28, 2025

Together with

DocumentDB Joins the Linux Foundation — DocumentDB is an MIT licensed document database built around a Postgres extension that Microsoft open sourced earlier this year. In an attempt to make the project more open and easier for multiple companies to work on, it is handing the project over to the Linux Foundation.

Kirill Gavrylyuk (Microsoft)

And.. AWS Joins the DocumentDB Project — A significant part of the announcement (above) is that AWS is joining the project, which must cause a little confusion for them as they already run the similarly named (but entirely unrelated in terms of code) Amazon DocumentDB. Nonetheless, this is another big win for Postgres, its extension-friendly nature, and anyone keen to bring MongoDB-like features to Postgres.

Amazon

PostgreSQL Performance? Diagnose It with pgNow — New to Postgres or just short on time? pgNow delivers fast, focused diagnostics helping you tune configs, fix slowdowns, and spot issues instantly. No setup, no agents, minimal permissions. Download for free and get started in seconds.

Redgate sponsor

IN BRIEF:

Earlier this month, Claire Giordano of the Talking Postgres podcast got to ▶️ speak with esteemed LLM-whisperer Simon Willison (not to mention, also co-creator of Django) about how AI is useful for data engineers today and his work more generally.
We'll feature it again when it's further along, but Shaun Thomas has started a series on doing Postgres extension development in C.

A Decade of Database Innovation: The Amazon Aurora Story — Amazon tells the tale of its Aurora service from the initial dream of being ‘a relational database for the cloud’ through to its modern day serverless approach.

Amazon Science

The Internals of PostgreSQL: An Introduction — A bit of a ‘golden oldie’ but one that continues to get updates. A good guide for experienced database users who want to go a little deeper with how Postgres works under the hood.

Hironobu Suzuki

📄 Using JWT to Establish a Trusted Context for RLS Tomas Vondra

📄 Why I Started Using Postgres (And You Might Too) – Brent is a (very) well known SQL Server expert and consultant but even he came to see its downsides. Brent Ozar

📺 Postgres 13 is End of Life, Here's How to Migrate to Version 17 PlanetScale

📄 Basic Cross-Database Operations with Foreign Data Wrappers Julien Singler

RELEASES:

pg_hint_plan 1.8: Tweak Query Execution Plans with 'Hints' — Postgres’ query planner usually does a good job of figuring out how to best execute a query against your data, but when it needs a little extra push in the right direction, this lets you drop some hints. Note that as of v1.8, it supports Postgres 18 only.

NTT OSS Center DBMS Development and Support Team

pg_cirrus 2.0: Set Up a Highly Available 3-Node Postgres Cluster — Configure a robust, fault-tolerant cluster with minimal manual intervention on Ubuntu or Red Hat. v2.0 adds support to configure a Pgpool-powered watchdog cluster to avoid the single point of failure present in previous setups.

Stormatics

pgmoneta 0.19.0 – Backup and restore solution for Postgres with support for incremental backups and various compression methods.
pg_parquet v0.4.3 – A way to export and import Parquet files directly within Postgres, without relying on third-party tools.
pg-promise 12.0 – Postgres interface for Node.js. Support for custom promises is now gone, now it's "ES6 Promise all the way".
PeerDB 0.33 – Stream data from Postgres to data warehouses, queues and storage engines.
BemiDB 1.2 – Single binary Postgres read replica optimized for analytics.
PostgREST 13.0.5 – A REST API for any Postgres database.
PostGIS 3.6.0 RC 2 – The geospatial Postgres extension.
pgAdmin 4 v9.7 – Popular Postgres admin tool.