--- title: "An offline Postgres expert-in-a-box" publication: "Postgres Weekly" issue: 635 published_at: "2026-02-11" canonical_url: "https://postgresweekly.com/issues/635" --- Plus postmaster bottlenecks, lock types explained, and pgstream 1.0's neat idea. | #​635 — February 11, 2026 [Web Version](https://postgresweekly.com/issues/635) Together with [![pgEdge\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1280,h_294/e_make_transparent/co_white,e_outline:17/fnv5xiqc6lewnu21fbch.png)](https://www.pgedge.com/?masthead) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/v1770818766/x4lxggckbr96igv3cbko.jpg)](https://www.recall.ai/blog/postgres-postmaster-does-not-scale) 📈 ['Postgres Postmaster Does Not Scale'](https://www.recall.ai/blog/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 [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/8d1b3557.png)](https://www.pgedge.com) [Enterprise Grade Postgres for Agentic AI, High Availability and More](https://www.pgedge.com) — 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](https://postgreslocksexplained.com/) — _“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](https://postgreslocksexplained.com/locks/lock_tool) to see which types of query use which types of lock. TheOtherBrian1 **IN BRIEF:** - 🗣️ There are many [Postgres User Groups](https://www.meetup.com/pro/postgresql/#groups) around the world, and they're looking for speakers. You can speak remotely too. Here's [how to register your interest.](https://docs.google.com/forms/d/e/1FAIpQLScPIA475eaejOzwWAQbBOlNclhRLgMFCbxl0snynu0TnCC2IA/viewform) - 🇹🇭 [The schedule](https://eventyay.com/e/b85fd0f2/schedule) for [FOSSASIA PGDay 2026](https://eventyay.com/e/b85fd0f2) (March 10 in Bangkok, Thailand) has been published. - There's going to be [a PostgreSQL Hands-On Training Day](https://www.socallinuxexpo.org/scale/23x/presentations/postgresql-hands-training-day) taking place as part of [SCALE 23x](https://www.socallinuxexpo.org/scale/23x) next month in Pasadena, CA. - Microsoft shares [its January monthly update covering _Azure Database for PostgreSQL_.](https://techcommunity.microsoft.com/blog/adforpostgresql/january-2026-recap-azure-database-for-postgresql/4492408) [Reading Buffer Statistics in `EXPLAIN` Output](https://boringsql.com/posts/explain-buffers/) — `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](https://postgres.fm/) — 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](https://postgres.fm/episodes/pgdog-update). Postgres FM podcast [Supporting ChatGPT on Postgres in Azure](https://techcommunity.microsoft.com/blog/adforpostgresql/supporting-chatgpt-on-postgresql-in-azure/4490247) — OpenAI recently shared [the story of scaling to 800 million users with Postgres](https://openai.com/index/scaling-postgresql/). Now, Microsoft shares their side of the story. Affan Dar (Microsoft) 📄 [Recreating PlanetScale's `pg_strict` in Rust: A Build Log](https://saybackend.com/blog/recreating-planetscale-pg-strict-in-rust/) – A way to catch dangerous UPDATE and DELETE statements before they run. Mohd Kamran Tahir 📄 [Building Personalized Search Without Leaving Postgres](https://www.paradedb.com/blog/personalized-search-in-postgresql) – A practical walkthrough of building a personalized recommender engine. Ankit Mittal (ParadeDB) **RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/v1770814087/dkqqzxypd0gfudnkrfoh.jpg)](https://github.com/ahacop/erwindb) 😍 [ErwinDB: A Postgres Expert in a TUI App](https://github.com/ahacop/erwindb) — 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](https://xata.io/blog/pgstream-v100-stateless-schema-change-replication) — 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.](https://github.com/xataio/pgstream) Xata [PGMQ: A Lightweight Message Queue Extension](https://pgmq.github.io/pgmq/latest/) — 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.](https://github.com/pgmq/pgmq) Tembo - [VectorChord 1.1](https://github.com/tensorchord/VectorChord/releases/tag/1.1.0) – 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](https://github.com/oban-bg/oban-py) – Python job orchestration framework, backed by Postgres. - [pgrx v0.17](https://github.com/pgcentralfoundation/pgrx/releases/tag/v0.17.0) – Framework for building Postgres extensions in Rust. - [PostGIS Patch Releases](https://postgis.net/2026/02/PostGIS-Patch-Releases/) – Bug fix releases for PostGIS 3.0-3.6. - [squawk v2.40](https://github.com/sbdchd/squawk) – Linter for Postgres migrations and SQL. - [pgAdmin 4 v9.12](https://www.pgadmin.org/docs/pgadmin4/9.12/release_notes_9_12.html) **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).