⚠️ Postgres 18.3, 17.9, 16.13, 15.17, and 14.22 Released — An out-of-cycle update to fix regressions introduced by last month's security releases. If you upgraded to 18.0, 18.1, or 18.2 already, you need to pay special attention as a manual step is required to make the json_strip_nulls and jsonb_strip_nulls functions immutable.

PostgreSQL Global Development Group

The Schedule is Out for POSETTE: An Event for Postgres! — POSETTE 2026, a free & virtual developer event, is happening June 16-18. The speakers and schedule were just announced! Join experts via 4 livestreams to learn about the world's most advanced open source relational database. Get the details.

Microsoft sponsor

We Have pgvector at Home — A fun bit of spelunking here. Turning to pgvector for your vector similarity searches is a sensible, modern option, but Postgres has a built-in extension that can (sort of) do it too: cube. Phil also surfaces an interesting gem in the shape of model2vec.

Phil Eaton

Coming to Postgres 19: INSERT .. ON CONFLICT .. DO SELECT — A preview of a quietly significant new feature to retrieve a conflicting row on an upsert rather than just ignoring or updating it. Laurenz explains why this is cleaner and safer than MERGE with some examples and use cases.

Laurenz Albe / CYBERTEC

Mostly Dead is Slightly Alive: Killing Zombie Sessions — I ain't afraid of no ghost! .. but zombie sessions are certainly annoying! This post looks at what keeps them around, how to get rid of them, plus some mitigations.

Lætitia Avrot

pgdsat 2.0: Database Security Assessment Tool — Checks your Postgres cluster for almost a hundred security related matters (like file permissions, config settings, replication setup, etc.) including all recommendations from the CIS compliance benchmark. The output is a report like this.

HexaCluster Corp

pgspot 0.9.2: Spot Vulnerabilities in Postgres Extension Scripts — An analysis tool for SQL scripts that checks for vulnerabilities and best practices.

Sven Klemm (Timescale)