In HOT Updates in Postgres we covered page pruning clean up HOT chains, an elegant shortcut where PostgreSQL reclaims dead tuple space during ordinary reads. All that without waiting for any background process. But pruning is exactly that:…
A PostgreSQL 14 database threw an error that PostgreSQL 14 cannot produce.

A few months ago, I spent time with multiple teams inside the same large financial services organization. I spoke with the data engineering team. The AI and model team. The platform team. The governance and compliance team. Each…
On 1st of July 2026, Masahiko Sawada committed patch: Add min() and max() aggregate support for uuid. The uuid type already has a full set of comparison operators and a btree operator class, so it is totally ordered. min() and max() were…