Sammlung von Newsfeeds
Cornelia Biacsics: Contributions for week 9, 2026
The community met on Wednesday, March 4, 2026 for the 7. PostgreSQL User Group NRW MeetUp (Cologne, ORDIX AG). It was organised by Dirk Krautschick and Andreas Baier.
Speakers:
- Robin Riel
- Jan Karremans
PostgreSQL Berlin March 2026 Meetup took place on March 5, 2026 organized by Andreas Scherbaum and Sergey Dudoladov.
Speakers:
Dave Page: AI Features in pgAdmin: Configuration and Reports
This is the first in a series of three blog posts covering the new AI functionality coming in pgAdmin 4. In this post, I'll walk through how to configure the LLM integration and introduce the AI-powered analysis reports; in the second, I'll cover the AI Chat agent in the query tool; and in the third, I'll explore the AI Insights feature for EXPLAIN plan analysis.Anyone who manages PostgreSQL databases in a professional capacity knows that keeping on top of security, performance, and schema design is an ongoing endeavour.
Radim Marek: Production Query Plans Without Production Data
In the previous article we covered how the PostgreSQL planner reads pg_class and pg_statistic to estimate row counts, choose join strategies, and decide whether an index scan is worth it. The message was clear: when statistics are wrong, everything else goes with it.
Bruce Momjian: New Presentation
I just gave a new presentation at SCALE titled The Wonderful World of WAL. I am excited to have a second new talk this year. (I have one more queued up.)
Gabriele Bartolini: From proposal to PR: how to contribute to the new CloudNativePG extensions project
In this article I walk you through the journey of adding the pg_crash extension to the new CloudNativePG extensions project. It explores the transition from legacy standalone repositories to a unified, Dagger-powered build system designed for PostgreSQL 18 and beyond. By focusing on the Image Volume feature and minimal operand images, the post provides a step-by-step guide for community members to contribute and maintain their own extensions within the CloudNativePG ecosystem.
Shaun Thomas: Using Patroni to Build a Highly Available Postgres Cluster—Part 1: etcd
The last PG Phriday article focused on the architecture of a Patroni cluster—the how and why of the design. This time around, it’s all about actually building one. I’ve often heard that operating Postgres can be intimidating, and Patroni is on a level above that. Well, I won’t argue on the second count, but I can try to at least ease some of the pain.To avoid an overwhelming deluge consisting of twenty pages of instructions, I’ve split this article into a series of three along these lines:
Andreas Scherbaum: PostgreSQL Berlin March 2026 Meetup
warda bibi: How PostgreSQL Scans Your Data
To understand how PostgreSQL scans data, we first need to understand how PostgreSQL stores it.
Zhang Chen: Inside the Kernel: The Complete Path to PostgreSQL Delete Recovery — From FPW to Data Resurrection
Zhang Chen: Expert-Level PostgreSQL Deleted Data Recovery in Just 5 Steps — No Kernel Knowledge Required
Robert Haas: pg_plan_advice: Plan Stability and User Planner Control for PostgreSQL?
I'm proposing a very ambitious patch set for PostgreSQL 19. Only time will tell whether it ends up in the release, but I can't resist using this space to give you a short demonstration of what it can do. The patch set introduces three new contrib modules, currently called pg_plan_advice, pg_collect_advice, and pg_stash_advice.
Read more »Jan Kristof Nidzwetzki: pg_plan_alternatives: Tracing PostgreSQL’s Query Plan Alternatives using eBPF
PostgreSQL uses a cost-based optimizer (CBO) to determine the best execution plan for a given query. The optimizer considers multiple alternative plans during the planning phase. Using the EXPLAIN command, a user can only inspect the chosen plan, but not the alternatives that were considered. To address this gap, I developed pg_plan_alternatives, a tool that uses eBPF to instrument the PostgreSQL optimizer and trace all alternative plans and their costs that were considered during the planning phase.
Lætitia AVROT: Mostly Dead is Slightly Alive: Killing Zombie Sessions
Muhammad Aqeel: pg_semantic_cache in Production: Tags, Eviction, Monitoring, and Python Integration
Part 2 of the Semantic Caching in PostgreSQL series that’ll take you from a working demo to a production-ready system.
Laurenz Albe: INSERT ... ON CONFLICT ... DO SELECT: a new feature in PostgreSQL v19
© Laurenz Albe 2026
PostgreSQL has supported the (non-standard) ON CONFLICT clause for the INSERT statement since version 9.5. In v19, commit 88327092ff added ON CONFLICT ... DO SELECT. A good opportunity to review the benefits of ON CONFLICT and to see how the new variant DO SELECT can be useful!
Cornelia Biacsics: Contributions for week 8, 2026
Prague PostgreSQL Meetup met on Monday, February 23 for the February Edition - organized by Gulcin Yildirim Jelinek & Mayur B.
Speakers:
Gilles Darold: pgdsat version 2.0
Floor Drees: Developer U: Exercising Cohesion and Technical Skill in PostgreSQL
Vibhor Kumar: Open Source, Open Nerves
Last year at the CIO Summit Mumbai, I had the opportunity to participate in a leadership roundtable with CIOs across banking, fintech, telecom, manufacturing, and digital enterprises.
The session was not a product showcase.
Shaun Thomas: How Patroni Brings High Availability to Postgres
Let’s face it, there are a multitude of High Availability tools for managing Postgres clusters. This landscape evolved over a period of decades to reach its current state, and there’s a lot of confusion in the community as a result.

