Postgres Weekly Issue 622: October 30, 2025

#622 — October 30, 2025

Together with

pgfeaturediff: Compare Features Between Postgres Versions — Powered by Postgres’s official feature matrix, this site gives you an easy way to directly compare the difference in features between two Postgres versions of your choice.

Sebastian Steenssøe

💡 PG Version Report is a similarly useful tool where you supply your server's version string and get to see CVEs, bugs, EOL dates, and a comparison with Postgres 17.

Agentic Postgres: Build AI Apps Natively in Postgres — Tiger Data’s new Agentic Postgres brings AI-native primitives to Postgres—forkable DBs, built-in memory, hybrid search, and agent APIs. Spin up zero-copy branches in seconds and experiment safely. Try it free on Tiger—no credit card needed.

TigerData sponsor

📊 Kafka is Fast, I'll Use Postgres — Inspired by a recent post about using Postgres instead of Redis, the author sets out to see if Postgres is good enough to handle use cases for which you might naturally consider Kafka.

Stanislav Kozlovski

💡 This post led to one of Hacker News's busiest discussions on Postgres this year.

IN BRIEF:

🇨🇭 CERN PGDay 2026 is a Postgres event taking place in the outskirts of Geneva next February 6. Its CFP is open till December 7.
🇪🇺 Floor Drees shares her experience of last week's PGConf EU event.
🎤 The Talking Postgres podcast caught up with Postgres contributor Andres Freund to discuss what went wrong (and right!) with implementing asynchronous I/O in Postgres 18.
👥 The Postgres project has updated its contributors page with several new contributors and four contributors promoted to Major Contributors.

pg_textsearch: True BM25 Ranking and Hybrid Retrieval — Impressed by ParadeDB’s BM25 ranking for full text search, Tiger Data wanted something they could run on their own Postgres-based system. Currently only in preview on Tiger Cloud, it’s uncertain if this will be open sourced in due course, but we’ve got our fingers crossed.

Green and Arye (Tiger Data)

📄 Returning Multiple Rows with Postgres Extensions – A handy read if you’re working on a Postgres extension of your own. Shaun Thomas

📄 Oracle’s Adoption of a Native Boolean Data Type vs. Postgres – Oracle finally gets a feature Postgres has had for decades. Pavan Chary

📄 Postgres 18's UUIDv7: Faster and Secure Time-Ordered IDs Vinicius Negrisolo

RELEASES AND CODE:

PostgREST 14.0: A REST API for any Postgres Database — A popular and long standing Haskell-powered server for providing a RESTful API to the Postgres database of your choice. v14.0 release notes.

Steve Chavez and Joe Nelson

📰 Classifieds

How note.com, Japan's top C2C creator platform, replaced its GitHub Actions + SSH proxy flow with JIT access control for more secure Aurora Postgres access.

🌐 Deploy anywhere at any scale with confidence, backed by dedicated support with decades of PostgreSQL experience.

pg_easy_replicate 0.4: Switch Databases with Minimal Downtime — A Ruby-powered orchestrator to simplify the task of setting up logical replication between two Postgres databases then letting you switch over to the newer one with minimal downtime.

Shayon Mukherjee

TimescaleDB 2.23 – Time series capabilities for Postgres in an extension. Now with full Postgres 18 support, UUIDv7 compression enabled by default, and the ability to set hypertables to unlogged.
WhoDB 0.66 – Lightweight next-gen data explorer for multiple databases.
PgDog 0.1.13 – Horizontal scaling for Postgres with automatic sharding.
ChartDB 1.17 – Open-source diagram-based database editor.