Postgres Weekly Issue 615: September 11, 2025

#615 — September 11, 2025

Together with

pg_duckdb 1.0: DuckDB-Powered Postgres for High Performance Analytics — An official Postgres extension (built in collaboration with Hydra and MotherDuck) that embeds DuckDB’s columnar-vectorized analytics engine and features into Postgres. GitHub repo.

DuckDB

Hands on Postgres 18: Async I/O, B-tree Skip Scan & More — With Postgres 18 set to release this month, now is the time to understand its performance-focused updates: from asynchronous I/O and planner changes, to B-tree Skip Scans, UUIDv7, VACUUM changes, and enhanced monitoring for production workloads.

pganalyze sponsor

Postgres 18 Release Candidate 1 Released — Just as we were about to hit ‘send’ last week, the official blog post about RC1 dropped and we snuck it in, but it was a quick mention, so worth featuring again in case you missed it. We also learn the final release is due in two weeks on September 25.

PostgreSQL Global Development Group

💡 Umair Shahid shares the three features he's most looking forward to in Postgres 18.

Supabase Opens the OrioleDB Patent to the Postgres Community — OrioleDB appeared three years ago as a new storage engine for Postgres. Supabase acquired it in 2024 and is now allowing others to use the technology described in the patent. Paul notes: "Our north star is to upstream Oriole to be part of the Postgres source tree, developed and maintained in the open alongside the rest of Postgres (if the community want it!)"

Paul Copplestone (Supabase)

IN BRIEF:

🇪🇸 Postgres Ibiza 2025 is taking place this October 15-17 on the beautiful island of Ibiza. What's it like? Jesús Espino wrote about his experiences at last year's event.
The Neon serverless Postgres platform has announced it's no longer locking premium features, like HIPAA and SOC 2 compliance, behind higher enterprise tiers – instead, making such features more 'pay as you go' for all users.
The Postgres project took part in Google Summer of Code again and one student participant, Ahmed Gouda, shares what he achieved with his work focused on pgwatch.
🇮🇳 PGConf India 2026 is taking place next March 11-13 in Bengaluru and its CFP is open till October 15.

Can Collations Be Used Over citext? — “A custom nondeterministic collation can indeed serve as an alternative to citext for case-insensitive queries, often with a much lower performance penalty.”

Umut Tekin

📄 Deep Dive into Postgres Internals: Process Architecture Srinath Reddy (EDB)

📄 Postgres 18 Eyes Analytics Boost and Distributed Future – The Register casts its eye over the forthcoming Postgres 18 release. Lindsay Clark

📄 A Trip to Vienna with Surprises – A write up of attending PGDay Austria which took place last week. Christoph Berg

📄 A 'TPC-C'-like 'Extension Pack' for pgbench Kaarel Moppel

RELEASES:

pgFormatter 5.7: A Tool to Format SQL Code — You can test it out online, or you can grab the source from GitHub (it’s written in Perl) and run it for yourself. What’s new in v5.7.

Gilles Darold

pgEdge goes Open Source — pgEdge is an enterprise-focused Postgres distribution concentrating on high availability, and distributed deployments that can work in a multi-master fashion. It was previously a commercial product with ‘source available’, but is now licensed under the OSI-approved PostgreSQL license.

Dave Page

vectorwrap: Universal Vector Search Wrapper — If you’re a Python developer, this lets you switch between Postgres, MySQL, SQLite, and DuckDB vector backends quickly.

Mihir Ahuja

pREST (PostgreSQL REST) 2.0 RC3 – Put a RESTful API in front of a Postgres database.
BemiDB 1.3 – Single binary Postgres read replica optimized for analytics.
pgai v0.12 – Timescale's tools to work with RAG and LLMs in Postgres.
pgroll 0.14.2 – Zero-downtime, reversible schema migrations.
Supavisor 2.7 – Supabase's multi-tenant connection pooler.