Sammlung von Newsfeeds

Discover how a PostgreSQL DBA’s decade of expertise evolved into designing Xata’s AI-powered Postgres agent, automating monitoring and observability.

© Laurenz Albe 2025

I recently helped a customer with a slow query. Eventually, an ANALYZE on a partitioned table was enough to fix the problem. This came as a surprise for the customer, since autovacuum was enabled. So I decided to write an article on how PostgreSQL collects partitioned table statistics and how they affect PostgreSQL's estimates.

The PostGIS Team is pleased to release PostGIS 3.6.0! Best Served with PostgreSQL 18 Beta3 and recently released GEOS 3.14.0.

This version requires PostgreSQL 12 - 18beta3, 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.

Are you in the Pacific Northwest?

In July 2025, during the PG19-1 CommitFest, I reviewed a patch targeting the lack of parallelism when adding foreign keys in pg_restore. Around the same time, I was helping a client with a large production migration where pg_restore dragged on for more than 24 hours and crashed multiple times.

In this blog, I will talk about the technical limitations in PostgreSQL, the proposed fix, and a practical workaround for surviving large restores.

Background 

There are two main types of backups in PostgreSQL:

Just recently, we announced the production-ready release of pg_tde, bringing open source Transparent Data Encryption (TDE) to PostgreSQL. Now, I may have spoiled the fun a little with the title, but take a look at the word puzzle below—can you guess the announcement? Bear with me… and my sense of humor, which might be a bit too dry for some :)

A deep dive into the evolution of my GSoC'25 project: the PostgreSQL ABI Compliance Checker. I share my journey of developing the ABICompCheck module using the PostgreSQL BuildFarm, learning Perl, setting up a CGI Server, and launching a public BuildFarm animal to run checks every 24 hours.

In the previous post, I discussed GSoC, my road to acceptance at PostgreSQL, and my project deliverables.

Today, I will share my experience with the PostgreSQL community, and the work I did.

Postgres Community Bonding

The first phase of GSoC is community bonding, where the mentee gets to know the community of his organization.

In the previous post, I discussed GSoC, my road to acceptance at PostgreSQL, and my project deliverables.

Today, I will share my experience with the PostgreSQL community, and the work I did.

Postgres Community Bonding

The first phase of GSoC is community bonding, where the mentee gets to know the community of his organization.

PGConf.EU’s first Community Events Day organized by community members: summits, showcases and trainings. Last few days to submit talks!

Clearly it's summer time in the Northern Hemisphere and we haven't been as punctual with our recognition posts! We'll resume to a more regular schedule, promised!

On Aug, 28 Peter Zaitsev and Emma Saroyan organised PG Armenia x Percona University.

Speakers: * Peter Zaitsev * Andrey Borodin * Emma Saroyan * Konstantin Trushin * Dmitrii Kochetov * Alexey Palazhchenko * Alex Demidoff * Eugene Klimov * Kim Saroyan * Alexander Zaitsev * Aya Guseinova * Piotr Kalmukhyan

Yesterday someone posted a set of queries for interviews, all centered on answering business-like questions from database. Today this post is hidden behind some “subscribe to read more" thing, so I will not even link it, but one question there caught my eye. Since I can't copy paste the text, I'll try to write what … Continue reading "Who logged to system from multiple countries in 2 hours?"

The PostgreSQL development group released the second Beta version of PostgreSQL 18 in July; the GA version is expected later in 2025 (around the September/October timeframe). The PostgreSQL development group and its community is very dedicated and ensures several minor releases during the year and major releases every year.

Row-level security (RLS) is a great feature. It allows restricting access to rows by applying filters defined by a policy. It’s a tool useful for cases when the data set can’t be split into separate databases.

PostgreSQL 19 changes this week ALTER DOMAIN ALTER DOMAIN ... VALIDATE CONSTRAINT executes at lock level ShareUpdateExclusivelock instead of ShareLock PL/Python event trigger support added sync_replication_slots if enabled, now requires wal_level to be set to logical

more...

The PostGIS Team is pleased to release PostGIS 3.6.0rc2! Best Served with PostgreSQL 18 Beta3 and recently released GEOS 3.14.0.

This version requires PostgreSQL 12 - 18beta3, 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.

The middle of August tends to be a quieter time in the PostgreSQL development cycle, so there's not much in the way of new developmentst to report.

This week's main item of interest is the quarterly release of PostgreSQL minor version updates.

PostgreSQL 19 changes this week

PostgreSQL 19 beta3 was released this week.

more...

When working with customers, a common question we get is: “Which standby type is best for our HA needs?” Before answering, we ensure they fully understand the concepts behind each standby type and provide the necessary guidance

A standby server is essentially a copy of your primary database that can take over if the primary fails.

There are different types of standby setups, each with its own use cases, pros, and cons. In this blog, we will discuss the three types: Cold Standby, Warm Standby, and Hot Standby.

PostgreSQL 19 changes this week pg_stat_progress_basebackup column backup_type added PostgreSQL 18 articles "enable" parameters will work differently in Postgres 18 (2025-08-07) - Michael Christofides / pgMustard

more...

This is the second part of the series I started on Learning PostgreSQL from AI and JSON exploration: Part 1. For this 2nd part, I decided to try gpt-oss the 14GB model which was just released in the past week. My first impression, "When will this ai shut up about its thinking process?".