#​662 — August 26, 2026 Web Version 🏖️ After a week of being Disneyed-out, I return tired, but more ready than ever to dive back into the (far less humid) waters of Postgres!__Your editor, Peter Cooper Postgres Weekly Eight Years of Postgres Advice, Re-Checked Against Postgres 19 — A look back at years of advice on COPY, TOAST, BRIN, covering indexes and partitioning, checking which behaviors and practices have changed over time. Per-topic tables show which version moved each needle, so it's a useful recap whatever version you're on. Christopher Winslett (Crunchy Data) Coming soon: ParadeDB Cloud — We're building a fully managed ParadeDB: one Postgres for your application data, full-text search, vector retrieval, and aggregations. Our early access waitlist is open now. ParadeDB sponsor Postgres 18.6, 17.11, 16.15, 15.19, and 14.24 Released — Landing just a day after our last issue, a huge round of releases including fixes for 28 CVEs. It isn't a simple update for everyone, either. GIN users on Postgres 18 need to check reltuples values, while users of btree_gist and ltree may need to reindex (see the "Updating" section for full details). PostgreSQL Global Development Group 💡 As part of the above wave of releases, Postgres 19 Beta 3 was also released with a large number of fixes and, notably, support for GROUP BY ALL was removed with its implementation pushed back to Postgres 20 – more details here. IN BRIEF: Pavel Stehule has created lua-psql, a set of patches to add experimental support for Lua into psql. Who helped Postgres take over the world? Michael Stonebraker's surprising answer is… Oracle! 🇺🇸 Tickets for Postgres Summit US 2026, taking place in NYC this September 30-October 2, are still available. Here's the schedule. 🎧 In the latest episode of Talking Postgres, Claire Giordano caught up with Datasette creator Simon Willison to discuss how AI is changing software development. Read Your Writes: WAIT FOR in Postgres 19 — A new SQL command (a decade in the making) that lets a session block until WAL reaches a specified position. So a read on an async replica can wait for the write it needs to see, rather than forcing every commit to wait for the standby. Gülçin Yıldırım Jelínek (ClickHouse) Does Anyone Run Postgres Without PgBouncer? — A survey of 20 managed providers shows nearly all bundle PgBouncer (or something similar) out of the box. So, asks Brandur, isn't it time pooling was just part of Postgres? Brandur Leach 💬 There's plenty of pushback in the Hacker News discussion, though, from those who think an app-side pool is all that's needed. 📄 Looking Forward to Postgres 19: Syntax Potpourri – A quick tour of assorted syntactic niceties. Shaun Thomas 📄 Why Postgres Breaks Kubernetes' container_memory_​working_set_bytes Metric Jeremy Schneider 📄 Building Safe MCP Servers for Your Postgres Database Pamela Fox (Microsoft) 📄 Migrating Multilingual Full-Text Search from SQL Server to Postgres Zhang and Ahmed (AWS) 📰 Classifieds Build a real-time dashboard on a live machine-data stream, on Postgres. Free workshop, Sept 9 at Noon ET. Save your spot. ❄️ GDPR deletion on archived data: one SQL, not a restore cycle. ColdFront's cold tier is writable. Open source. RELEASES AND CODE: pg_statviz 1.2: Time Series Analysis and Visualization of Postgres Stats — An extension and utility pairing for performing time series analysis and visualization of various statistics around I/O, locks, WAL, buffer use, and more. v1.2 adds Postgres 19 support, a blocking locks analysis module, and supports using OpenAI-compatible endpoints for AI analysis of the results. Jimmy Angelakos pgbot: Postgres Intelligence for AI Agents and Apps — A Go-powered, single binary read-only tool that connects to a Postgres server and prints a graded health report plus what changed since the last run. Only two weeks old, so early days. GitHub repo. Alex Shapalov 🔎 pg_textsearch 1.4 – Tiger Data's BM25 ranked text search extension now supports Chinese and has big speedups for top-K queries that use WHERE filters. pgGraph 1.2 – Graph indexing, search and traversal over ordinary tables. No longer has a 254 label ceiling; graphs can now contain up to 1 million distinct types. pg_stat_ch 0.4 – Captures per-query execution telemetry and exports it to ClickHouse for analysis in real-time. 🌐 PostGIS 3.7.0 RC1 – The popular geospatial data extension. Fixes bugs and targets Postgres 19 Beta 3. pgBackRest 2.59.1 – Popular reliable backup and restore solution. It, too, now supports Postgres 19 Beta 3. PGSync 7.3 – Middleware for syncing data from Postgres to Elasticsearch. PostgREST 16.2 – Serve a fully RESTful API from an existing database.