#​628 — December 11, 2025

Web Version

🗓️ Note that Postgres Weekly will be moving to Wednesdays in January 2026, as part of a reshuffle for most of our newsletters. We still have one more week before the Christmas break, though, so we'll be back next Thursday with our 2025 roundup!
__
Your editor, Peter Cooper

Together with  Tiger Data logo

Postgres Weekly

Scan Types in EXPLAIN Plans Explained — Using EXPLAIN to understand how a query is run can be a huge help in debugging performance issues or optimizing your SQL, but what do things like “Seq Scan” and “Index Scan” really mean? Elizabeth breaks down several main scan types here, complete with diagrams – you’ll almost certainly learn something!

Elizabeth Christensen

TimescaleDB at CERN: Massive Time-Series at Unmatched Scale — CERN’s NextGen Archiver chose TimescaleDB for extreme throughput, 7-10x compression, and 10-40x faster reads. See how PostgreSQL + TimescaleDB now powers 500+ systems and is set to become CERN’s standard for historical data storage.

Tiger Data sponsor

IN BRIEF:

What You Should Know About Constraints in Postgres — You can define constraints on your tables and columns to enforce conditions on your data. Gulcin digs into the details.

Gulcin Yildirim Jelinek (Xata)

Closing The Loop: Building a Coding Agent That Uses Postgres Branches — The folks at Xata built an agent (which is actually open source) specifically for monitoring databases to find problems and suggest fixes.

Divyendu Singh (Xata)

Postgres, MongoDB, and What “Cannot Scale” Really Means — Reflections on a recent The Register story where MongoDB’s CEO was quoted as saying “PostgreSQL could not just scale”.

Umair Shahid

📄 What I Learned Using Neon Postgres for a Week of Live Traffic – Good reflections on the pros and cons of a serverless billing approach. Ishan Das Sharma

📄 Adding Async Streaming to Postgres Foreign Data Wrappers Bo Lu (Supabase)

📄 A Deeper Look at UUIDv4 vs UUIDv7 in Postgres 18 Josef Machytka

RELEASES AND CODE:

temBoard 10.0: A Postgres Remote Control/Dashboard — A Python-built Web dashboard and monitoring system for Postgres. You install an agent on the servers in question and the temBoard webapp runs wherever you like. v10 brings Postgres 18 support and runs on Python 3.9+ with RPM and DEB packages also available. GitHub repo.

Dalibo

📰 Classifieds

🌎 Introducing streamlined HA PostgreSQL deployments (distributed or single-region) on Kubernetes, leveraging CNPG integration with pgEdge.

$5 PostgreSQL now available. Stop overpaying for idle instances with the new developer tier from Aiven.

VectorChord 1.0: Fast Vector Search on Postgres — First unveiled just a year ago, the promising, performance-oriented vector indexing and querying extension has reached v1.0. We mentioned the release last month, but the team has now put together this blog post digging into just how VectorChord achieves so much added performance versus pgvector.

Jinjing Zhou

💡 They go into even more technical depth in the post How We Made 100M Vector Indexing in 20 Minutes Possible on PostgreSQL.

Introducing pg_clickhouse: A Postgres Extension for Querying ClickHouse — ClickHouse is a popular open-source OLAP system and this extension provides a way to transparently execute analytics queries on ClickHouse directly from Postgres.

David Wheeler (ClickHouse)