#​635 — February 11, 2026

Web Version
Together with  pgEdge

Postgres Weekly

📈 'Postgres Postmaster Does Not Scale' — A case study revealing a bottleneck in Postgres's single-threaded postmaster process with bursty workloads. Elliot comes armed with charts and diagrams illustrating the problem, and how his team increased throughput. Connection pooling or proxying mitigates this in most cases, though, and if you're turning max_connections up high, it's time to check your connection management strategy.

Elliot Levin

Enterprise Grade Postgres for Agentic AI, High Availability and More — pgEdge delivers open-source, 100% Postgres infrastructure for Agentic AI and enterprise apps that demand high availability, reliability, and data sovereignty. We make it easy to build, deploy and manage enterprise‑grade Postgres apps at scale.

pgEdge sponsor

🔒 Postgres Locks Explained — “It’s the resource I wish existed when I first started learning about locks”, says the author (an engineer at Supabase) of this site focused solely on explaining the different types of lock used in Postgres in an easy-to-understand way, complete with an interactive diagram to see which types of query use which types of lock.

TheOtherBrian1

IN BRIEF:

Reading Buffer Statistics in EXPLAIN Output — EXPLAIN’s buffer statistics help you zero in on where the time went (I/O being a notorious cause of latency!) when you’re investigating a query. Learn what shared hits, disk reads, temp spills, and planning buffers actually mean, and how to use these numbers to diagnose real perf problems.

Radim Marek

▶  Postgres FM: A Weekly Postgres Podcast — Michael Christofides and Nik Samokhvalov have been showing up nearly every week for almost four years now, usually with an impressive guest in tow, and it keeps getting better. Case in point: their recent chat with PgDog’s Lev Kokotov.

Postgres FM podcast

Supporting ChatGPT on Postgres in Azure — OpenAI recently shared the story of scaling to 800 million users with Postgres. Now, Microsoft shares their side of the story.

Affan Dar (Microsoft)

📄 Recreating PlanetScale's pg_strict in Rust: A Build Log – A way to catch dangerous UPDATE and DELETE statements before they run. Mohd Kamran Tahir

📄 Building Personalized Search Without Leaving Postgres – A practical walkthrough of building a personalized recommender engine. Ankit Mittal (ParadeDB)

RELEASES AND CODE:

😍 ErwinDB: A Postgres Expert in a TUI App — This tickled me! It's a TUI to browse and query Postgres contributor Erwin Brandstetter's Stack Overflow answers. It works offline and covers thousands of his high-quality answers over the years, complete with semantic search.

Ara Hacopian

pgstream 1.0: Postgres Replication with DDL Changes — This CDC tool now replicates schema changes by emitting DDL events directly into the WAL, using the DDL statement as the source of truth. A neat approach if you've dealt with schema drift or CDC breaking on schema evolution. GitHub repo.

Xata

PGMQ: A Lightweight Message Queue Extension — Think AWS SQS but inside Postgres with no background workers or external dependencies. You get guaranteed ‘exactly once’ delivery of messages, API parity with SQS, FIFO queues, and more. GitHub repo.

Tembo

  • VectorChord 1.1 – Efficient vector similarity search extension, now with 8 and 4-bit RaBitQ quantized vector types so you can use even less storage.

  • Oban 0.5 – Python job orchestration framework, backed by Postgres.

  • pgrx v0.17 – Framework for building Postgres extensions in Rust.

  • PostGIS Patch Releases – Bug fix releases for PostGIS 3.0-3.6.

  • squawk v2.40 – Linter for Postgres migrations and SQL.

  • pgAdmin 4 v9.12