Sammlung von Newsfeeds

I had the pleasure of speaking at PGConf.dev in Montreal, where I delivered a session on Columnar Data Store—a topic that’s quietly transforming the way we handle large-scale analytics in PostgreSQL. In this post, I’ll walk you through the core ideas from my talk and explain why columnar storage isn’t just a performance boost—it’s a game changer for modern data workloads.

Catching with all contributions. PGDay UK published their schedule. Registration is still open. Here is their program committee

PgDay UK

Sharing my progress on how I am working on ABI compliance reporting for PostgreSQL as a BuildFarm Module. In this post, I walk through the new workflow, highlighting lessons learned from community feedback, and discuss upcoming improvements. If you're curious about ABI checking for Postgres Binaries and how it integrates with BuildFarm, this post is for you!

You probably saw the story about your public ChatGPT queries being indexed by Google and other search engines. Yikes! 
You may want AI with your data but do not wish your prompts to end up in a search engine, especially if you are working with sensitive data.  

Nordic PGDay 2026 will return to Helsinki, Finland, on March 24. See our website for details, and stay tuned for more!

This week's edition is unfortunately delayed due to personal reasons.

PostgreSQL 19 changes this week psql : variable SERVICEFILE added PostgreSQL 18 changes this week

Main item of note this week: PostgreSQL 18 Beta 2 has been released

more...

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.

A case study on how Bilt reduced Postgres query timeouts by 95% with ParadeDB

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?

Why Databases? Why PostgreSQL?

In today’s digital world, data is at the heart of every application, from social media platforms to banking systems, from e-commerce websites to IoT devices. To manage this data efficiently, reliably, and securely, we need a robust system known as a database management system (DBMS). Among the many DBMS options available, PostgreSQL stands out as a top choice for developers and enterprises alike. 

Here’s why PostgreSQL is a go-to database for modern applications:

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. 

Introduction

In our previous blog, we have done an introduction to CloudNativePG (CNPG) and showed how we can create a single instance cluster. In this blog, we’ll walk through creating a PostgreSQL cluster using initdb with custom options, manage roles, and create databases—all declaratively with Kubernetes manifests.

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.