Sammlung von Newsfeeds
Christophe Pettus: All Your GUCs in a Row: ignore_system_indexes
Devrim GÜNDÜZ: Release Radar: A Self-Hosted Watchtower for Upstream Releases (and Why It Matters for PGDG Packaging)
Release Radar, a self-hosted project written by Claude and me, is built to close exactly that gap.
** What it does
Shaun Thomas: Looking Forward to Postgres 19: Syntax Potpourri
Before diving into this final post covering new Postgres 19 features, I just want to say it's been a wild ride. Postgres 19 has been a veritable treasure trove of enhancements, perhaps more than any previous release; or maybe that's just my perception. Usually I just skim through the release notes and nod along, sometimes jotting down things that look interesting for later study. Maybe calling out each element that caught my eye was the right thing to do, to really show how far Postgres has come since the last release, rather than simply accepting the status quo.
Cornelia Biacsics: Contributions for week 29 & 30
The Talk Selection Committee of PGConf.EU 2026 met to finalize the conference schedule:
Christophe Pettus: All Your GUCs in a Row: ignore_invalid_pages
Andrei Mironov: PostgreSQL Row-Level Security for AI Agents: A Testable Setup
Pavel Stehule: initial integration lua language to psql
Antony Pegg: Postgres for Agentic AI: Your Database Is a Compute Layer, Not a Parking Lot
PostgreSQL is already the default database for agentic AI. That question is settled. But the more agentic your workloads get, the more your database needs to do. Models and workflows flood it with signals, state, memory, and checkpoints, and most teams just absorb the flood, treating PostgreSQL like a parking lot rather than a compute layer. The people building these systems are AI engineers, not database people.
Gabriele Bartolini: CNPG Recipe 26 - Extension image catalogs
CloudNativePG lets the ClusterImageCatalog carry extension images alongside the operand, a capability every currently supported release already has, so a Cluster manifest only needs to name an extension and nothing else. This recipe deploys the community’s extension catalog and shows the operator resolving pgvector’s image, paths and dependencies from a single, versioned source of truth per PostgreSQL major version.
Mayur B.: EXPLAIN ANALYZE the PGConf.EU CFP
What I learned after moving from conference volunteer duty to the other side of the Call for Papers.
Christophe Pettus: All Your GUCs in a Row: ignore_checksum_failure
Radim Marek: The DISTINCT in your COUNT
Here is a query that shows up in every analytics workload:
SELECT count(DISTINCT user_id) FROM events;It looks like the cheapest possible thing: count the distinct users. On a machine with cores to spare you would expect Postgres to throw a few parallel workers at it, the way it does for almost any large scan. It does not. That one keyword, DISTINCT, switches off parallel query for the entire statement, and the larger your table the more it costs you. No setting or index changes that; the reason is in how the aggregate has to execute.
Christophe Pettus: Ontogeny Recapitulates the Relcache
Avi Vallarapu: Tuning PostgreSQL HOT Updates - A HammerDB Benchmark
Christophe Pettus: All Your GUCs in a Row: idle_session_timeout
What if Claude were your Postgres server?
#660 — August 5, 2026
Lots of videos from this year's PGConf.dev are now on YouTube and I've rounded up some highlights at the end of the issue!
__
Your editor, Peter Cooper
Postgres Weekly
Wellingtone Luvonga: Mastering PostgreSQL Configuration Management with CloudNativePG (CNPG)
If you are a traditional database administrator (DBA) transitioning to Kubernetes, the cloud-native ecosystem can feel like a series of personal attacks on your workflow.
For years, your terminal was your home. If a query was running slow, you SSH’d into the VM, opened /var/lib/pgsql/data/postgresql.conf in vim, bumped up shared_buffers, and ran a quick pg_ctl reload. If you needed to lock down access for a new application server, you hopped into pg_hba.conf, appended a new host rule, and went about your day.
Christophe Pettus: All Your GUCs in a Row: idle_replication_slot_timeout
Umair Shahid: PostgreSQL Lockup vs Stale Connection: How to Tell Them Apart
“The database is locked up.” We heard some version of that sentence more than once this past week, from the same team, about what looked like the same problem. It was not the same problem. Once, Postgres had genuinely stopped responding. Every other time, Postgres was fine, and a connection sitting in the application’s pool had quietly died somewhere between the app and the database.
