Neues vom PostgreSQL Planet

It's Sunday and I'm now sitting in the train from Brest to Paris where I will be changing to Germany, on the way back from the annual Debian conference. A full week of presentations, discussions, talks and socializing is laying behind me and my head is still spinning from the intensity.

Pollito and the gang of DebConf mascots wearing their conference badges (photo: Christoph Berg)

Table of Contents

Ollama is an open-source project that simplifies running large language models (LLMs). It runs locally on your machine, and you can choose from multiple LLMs. Keeping all the data on your machine should provide a security bonus.   

DBeaver is a universal database tool with an AI Assistant. This assistant provides an extra layer of security by allowing you to lock down what is shared, with the default being metadata only, no data.

PostgreSQL Person of the Week Interview with Polina Bungina: I am Polina, a PostgreSQL database engineer at Zalando, located in Berlin, Germany. However I am originally from St. Petersburg, Russia.

Greetings!

I work in Tantor Labs as a database developer and naturally I am fond of databases. Once during reading the red book I have decided to study planner deeply. Main part of relational database planner is join ordering and I came across DPhyp algorithm that is used in most modern (and not so much) databases. I wonder - is there is anything in PostgreSQL? Surprisingly, nothing. Well, if something does not exist, you need to create it yourself.

I'm excited to announce that Postgres AI has started work on a new project – open-source Self-Driving Postgres (SDP).

In the AI era, Postgres is the natural choice for AI builders. With fast-growing database clusters, the highest level of automation is essential. AI-driven growth demands efficient, proactive, and intelligent database management. Our goal is to reduce manual interventions as much as possible to achieve the highest level of operational efficiency and reliability.

How can we define levels of automation?

Today, as part of our Launch Week (Day 4), we're excited to announce the release of our Postgres how-to guides collection – a comprehensive set of dozens of practical guides covering real-world PostgreSQL challenges.

 Structured Query Language, or SQL, is my favorite programming language, but its quirky syntax can sometimes be frustrating. Many have professed a need to bypass SQL and query databases in English (another quirky language. Is it possible to have an Artificial Intelligence take a request in English and translate it into SQL on my behalf?

I am using the AI Chat Feature of DBeaver Enterprise to test. 

Postgres AI Checkup service: expert-led, AI-assisted comprehensive database health assessment

This is Day 3 of Postgres AI launch week

It starts innocently enough.

You choose Postgres – solid, reliable, battle-tested. You pick a managed service like RDS or CloudSQL. They handle backups, high availability, disaster recovery. You can focus on building your product. Life is good.

 If you've ever wanted to skip SQL and its quirks and write queries in English, I am happy to report that you can do it with an AI of your choice and DBeaver. I have a webinar on July 24th that shows you how to do just that.  

If you missed Prairie PUG meetup, here is the recording!

There will be no meetup in August – we will see you on September 10. Please keep an eye on announcements!

A year ago we renamed the Talking Postgres podcast—and just published our 29th episode. Since it’s a monthly thing, that means 13 new conversations in the past year. So this feels like a good moment to pause, reflect, and share a few highlights.

Three events published their schedule. Here are the Program Committees behind that work. Registrations are open for these three events.

PgDay Austria

© Laurenz Albe 2025

You may have encountered the abbreviation PGDG or the long version “PostgreSQL Global Development Group” in the PostgreSQL license text, the name of installation packages and elsewhere. But have you ever stopped to think who this mysterious organization is? Have you ever wondered how one becomes a member? Then read on.

PostgreSQL Person of the Week Interview with Peter Zaitsev: I was born and raised in Moscow, Russia, graduated from Moscow State University and had my first startup there. In 2004 I moved to the US while working at MySQL AB.

 A couple weeks back, I received my speaker's gift from POSETTE: An Event for Postgres. 

I regularly update my slides to reflect improvements, corrections, and changes to Postgres. Recently I have made changes to two of my slide decks that I would like to highlight. First, my talk Postgres Scaling Opportunities is a rarely-presented deck about the ways Postgres can be scaled. One thing I always felt diminished the usefulness of that presentation was a clear explanation of why scaling databases is so complex.

The PostGIS Team is pleased to release PostGIS 3.6.0beta1! Best Served with PostgreSQL 18 Beta2 and soon to be released GEOS 3.14.

This version requires PostgreSQL 12 - 18beta2, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.14+ is needed. To take advantage of all SFCGAL features, SFCGAL 2.2.0+ is needed.

 A couple weeks back, I received my speaker's gift from POSETTE: An Event for Postgres. 

Pgroll is an open-source, zero-downtime, reversible schema migration tool built exclusively for Postgres. We’ve reached 5k stars on GitHub!

I am very thankful to everyone who attended yesterday’s meetup! I must be completely honest: I am always pleasantly surprised when people attend our summer meetups. There are so many better things you can do in Chicago in summer!

I am especially thankful to our speaker, Robert Ismo, who delivered a very interactive presentation about AI and Postgres and kept the audience engaged. In fact, the lively discussion lasted until I had to go to catch my train and asked people to relocate to continue their discussion, so I can’t even tell how long it lasted :).