Postgres Weekly Issue 623: November 6, 2025

#623 — November 6, 2025

Together with

Don't Give Postgres Too Much Memory — The more memory, the better, right? Not when it comes to Postgres’ maintenance_work_mem and work_mem settings, as Tomas demonstrates here. CPU cache size and OS memory management play key roles in the results.

Tomas Vondra

Introducing pg_lake: Integrate Your Data Lakehouse with Postgres — A set of extensions that add comprehensive Iceberg support and data lake access (including Parquest, CSV and JSON support) to Postgres, with DuckDB transparently integrated into the query engine for fast execution without leaving Postgres. GitHub repo.

Craig Kerstiens (Snowflake)

Build AI Apps with Postgres on Azure — Explore practical steps and tools to bring advanced AI capabilities into your apps. Learn how to integrate Azure AI and Machine Learning with Postgres on Azure to build intelligent, AI-powered applications. Start learning.

Microsoft sponsor

IN BRIEF:

🗓️ The PostgreSQL Event Calendar is a site keeping track of Postgres-oriented events and also hosts an ICS / iCalendar file you can add to your own calendar app. Events currently run through to 🇦🇹 PGDay Austria taking place in September 2026.
postgres-contrib.org is a blog rounding up contributions made to the Postgres project on a mostly weekly basis.
🇨🇿 If you'd like to speak at Prague PostgreSQL Dev Day 2026, its CFP closes next week. It takes place on January 27-28 in Prague, Czechia.
It's not available yet, but PlanetScale's announcement of a forthcoming $5/mo Postgres plan caused some excitement on social media this week.

🇪🇺 A PGConf EU 2025 Trip Summary — Europe’s main Postgres conference took place in Latvia two weeks ago and Claire (of the Talking Postgres podcast) shares a detailed trip report covering her role as speaker, Microsoft representative, and more. Lots of photos too.

Claire Giordano (Microsoft)

💡 Cybertec's Cornelia Biacsics has put together a similar report of her own.

📄 "You Don't Need Kafka, Just Use Postgres" Considered Harmful – A response to an article we featured last week. Gunnar Morling

📄 How to Listen to Database Changes Through the WAL Peter Ullrich

📄 Transaction Pooling in Postgres with Pgcat Phil Eaton

📄 A SQL Query's Roadtrip Through Postgres Jesús Espino

📄 What Are 'Dirty Pages' in Postgres? Umair Shahid

RELEASES AND CODE:

pg_timetable 6.1 Released: Advanced Job Scheduling Extension — A mature, advanced standalone job scheduler extension that lives entirely in your database and lets you schedule Postgres commands and queries, system programs and built-in operations, as well as chain tasks together.

CYBERTEC PostgreSQL International GmbH

📰 Classifieds

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

🧠 The 100% open-source PostgreSQL you trust: now enterprise-grade and globally distributed-ready.

PostGraphile v5 Release Candidate — PostGraphile provides a way to create an automatic GraphQL API backed by a Postgres database (akin to how PostgREST puts a RESTful API in front of a database). v5 has been five years in the making and is.. almost here.

Benjie and Jem

PGSync 6.0 – Postgres to Elasticsearch/OpenSearch syncing. As of v6.0 it has MySQL/MariaDB support too.
Stateless Postgres Query Router (SPQR) 2.8 – An approach to horizontal sharding, originally built at Yandex Cloud.
PostgREST 14.1 – A REST API for any Postgres database.
Squawk 2.30 – Linter for Postgres migrations and SQL.