#652 — June 10, 2026

Together with

PostgreSQL 19 Beta 1 Released — One of the more exciting major releases of Postgres is a step closer with graph queries, faster inserts, pg_plan_advice, parallel-worker autovacuuming, online toggling of data checksums, and more, all ready to try now. Final release will be around late September/early October.

PostgreSQL Global Development Group

💡 Ready to give Postgres 19 a spin? Here's how to get it running in Docker or on a Kubernetes cluster.

Come for Great PostgreSQL Talks, and Yes, There’s Swag — POSETTE: An Event for Postgres is around the corner (16-18 Jun). Pick & attend your must-sees. Join the Hallway Track on Discord for limited, exclusive event swag for attendees to the live event from anywhere in your slippers. Last call: Register now.

Microsoft | AMD sponsor

IN BRIEF:

📘 The official Postgres 19 documentation is now taking shape, such as this page on property graphs and the draft release notes.
💰 Supabase has raised a $500m Series F round at a valuation of $10bn.
Spectral Core has unveiled SQL Tran, a (commercial) tool for automating Oracle to Postgres migrations.

⚾ Comparing the Graph Capabilities of Postgres, DuckDB, and LadybugDB — A baseball-oriented comparison of how three databases fare (both in terms of developer experience and raw performance) with making graph-style queries across millions of rows of player, venue, and game data.

John Nevin

EXPLAIN Prettier (or Post-Processing Query Plans) — EXPLAIN output can be tricky to read at the best of times and it can also change subtly between machines and versions. Andrei shows off explain_prettier, which makes EXPLAIN output cleaner and simpler by stripping away unnecessary info.

Andrei Lepikhov

📄 The Postgres Developer's Guide to Vector Index Tradeoffs – Find out what HNSW, IVFFlat, DiskANN, and SPFresh indexes are and when to pick each of them. Hien Phan (Tiger Data)

📄 SQL’s ORDER BY Has Come a Long Way – A feature tour from the 80s through to the ISO-specified SQL:2023 present. Markus Winand

📄 Does pgBackRest Work with pg_tde? – Can pgBackRest handle encrypted WAL segments transparently? Mostly, yes! Stefan Fercot

📄 File Descriptors: The OS Limit That Takes Down Postgres Warda Bibi

📰 Classifieds

🧮 Build a full RAG stack inside Postgres. Docloader, Vectorizer, RAG, & MCP. 100% open source.

🐘 AI wrote the migration. Who reviews it? Open-source multi-agent PR review - a custom review lens per PR, cents per run. Star & deploy →

RELEASES AND CODE:

Absurd: A Postgres-Native Durable Workflow System — Described as “the simplest durable execution workflow system you can think of”, Absurd is an SQL file that implements a multi-step task/queue/worker system on regular Postgres. There are SDKs to make it easy to use from TypeScript, Python, and Go.

Armin Ronacher (Earendil)

Multigres v0.1 Alpha: An 'Operating System' for Postgres — A year ago, Supabase announced it was hiring the co-creator of Vitess to work on a Vitess-like horizontally-scaling database clustering system but for Postgres. This alpha is an early public look at what they’re building.

Sugu Sougoumarane

TimescaleDB 2.27 – Tiger Data's time series extension continues its focus on performance with more efficient operations on compressed data in particular.
pg_clickhouse 0.3 – FDW for querying ClickHouse databases from Postgres. The underlying C++ library gets switched out for a faster, more robust C alternative.
pg_background 2.0 – Run SQL in background workers. Now works with Postgres 19.
Kanel 4.0 – Generate TypeScript types from a live Postgres database.
pgrls – Static analyzer for RLS (Row-Level Security) to catch common policy bugs.
NeonD – Open-source Neon-based control plane daemon for Postgres that runs as a single Docker container.
pgcheck – A lightweight Postgres health-check CLI written in Go.

Got a new email? You can change your address here.

Bored of us? Click here to stop getting Postgres Weekly.

Got a link for us? Reply and tell us. We can't include everything but we'll look at anything you send. Thanks!

Published by Cooper Press Ltd.
Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom

Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada.

Stop getting this newsletter.