Neues vom PostgreSQL Planet

Today I added openSUSE Leap 16.0 support to the PostgreSQL RPM repository. Please find all details here:
https://zypp.postgresql.org/

You can find the repository RPM here: https://zypp.postgresql.org/repopackages/

This release includes all packages, including the "extras" repository.

Report any issues here: https://github.com/pgdg-packaging/pgdg-rpms/issues/new

PaulWhalen’s talk recording is now available! Enjoy!

Introduction: The Market Is Talking About AI, but the Deeper Change Is Architectural

The database market is full of confident declarations right now. One vendor says the cloud data warehouse era is ending. Another argues that AI is redrawing the database landscape. A third claims that real-time analytics is now the center of gravity. Each story contains some truth, and each vendor naturally presents itself as the answer.

Your PostgreSQL HA cluster promotes a new primary. Patroni says everything is healthy. But your application is still talking to the old, dead node. Welcome to the OCI VIP problem.

If you have built PostgreSQL high availability clusters on AWS or Azure, you have probably gotten comfortable with how virtual IPs work. You assign a VIP, your failover tool moves it, and your application reconnects to the new primary. Clean. Simple. Done.

Introduction

Most people who work with PostgreSQL eventually learn two commands for query tuning: EXPLAIN and EXPLAIN ANALYZE.

EXPLAIN shows the planner’s chosen execution plan, and EXPLAIN ANALYZE runs the query and adds runtime statistics. For most tuning tasks, this already provides a wealth of information.

But what many people don’t realize is that EXPLAIN has a handful of other options that can make troubleshooting much easier. In some cases they answer questions that EXPLAIN ANALYZE alone cannot.

The PostgreSQL User Group Vienna met for the very first time on Wednesday, March 18 2026, organised by Cornelia Biacsics.

Speakers:

• Ranjeet Kumar
• Jan Karremans
• Pavlo Golub

On Thursday, March 19 2026, the AMS DB came together for talks and networking.

Organised by:

I'm a Product Manager. Not a developer. I want to be upfront about that because everything that follows only makes sense if you understand that I have no business writing software - and I did it anyway.I built MM-Ready, an open-source CLI tool that scans a PostgreSQL database and tells you exactly what needs to change before you can run multi-master replication with pgEdge Spock.

A feature about how to handle harhref keys when querying a table.

Perl and DBI hashref keys case-sensitive

Perl and DBI are brilliant in giving you power to connect to a database and extract data. There is however something I never noticed, because I’m used to a PostgreSQL: when fetching a row as an hashref, the keys are stored in lowercase. This is not something tied to DBI, nor to Perl, rather to PostgreSQL and the way it handles SQL.

On 12nd of March 2026, Robert Haas committed patch: Add pg_plan_advice contrib module.   Provide a facility that (1) can be used to stabilize certain plan choices so that the planner cannot reverse course without authorization and (2) can be used by knowledgeable users to insist on plan choices contrary to what the planner believes … Continue reading "Waiting for PostgreSQL 19 – Add pg_plan_advice contrib module."