Neues vom PostgreSQL Planet
Ian Barwick: PgPedia Week, 2025-09-21
Dave Stokes: PostgreSQL 18 Release Notes
The PostgreSQL 18 Release Notes are like a great noir novel, full of surprises and intrigue. But we know who did it - the amazing PostgreSQL community.
Deepak Mahto: Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendly
PostgreSQL 18 was released on September 25, 2024, introducing a host of exciting new features across all major areas. In this blog series, we’ll delve into these features and explore how they can benefit database developers and migration engineers transitioning to PostgreSQL.
Part 1 of the series focuses on enhancements to the COPY command, particularly for use cases involving loading external files into the database.
Henrietta Dombrovskaya: How I learned to use wal_inspect
It has been a while since last time I blogged about any real-database-life problems and investigation. Here is one which I am really happy about, because it took a while and it was not obvious, but I found the root cause of a problem!
Umair Shahid: Query optimizations in Odoo versions 17–19 for faster PostgreSQL performance
We get a lot of queries about performance optimization for PostgreSQL from organizations using Odoo. The platform has been built entirely on PostgreSQL, and Odoo’s ORM and database layer have undergone several performance‑oriented changes across releases 17, 18, and 19 to reduce SQL overhead and take better advantage of PostgreSQL.
I have always maintained that SQL optimization is the most significant factor contributing towards database performance improvements, so I am very happy to see these improvements being rolled out.
Gabriele Bartolini: Run PostgreSQL 18 on Kubernetes Today with CloudNativePG
PostgreSQL 18 is officially released, packed with improvements for performance, authentication, operations, and security. In this article, I’ll show you how to run it on Kubernetes from day one with CloudNativePG. I will summarise key new features like asynchronous I/O and OAuth 2.0, as well as the extension_control_path parameter. This is a simple but critical feature for operational control in cloud-native environments, and one our team at CloudNativePG and EDB was proud to help contribute to PostgreSQL.
Umut TEKIN: Exploration: CNPG Point In Time Recovery
In our CNPG series, we have mentioned that backups are crucial in every database system in case of any disaster. PostgreSQL has powerful recovery capabilities as well as backup capabilities, including the ability to restore a database cluster to a specific moment in time. This is extremely useful in scenarios where we need to recover from user errors—such as accidental data deletion, wrong updates, dropped tables, or even dropped databases.
Floor Drees: Contributions for the week 38
Daria Aleshkova, Oleksii Kliukin, Sergey Dudoladov and Andreas Scherbaum organized the PostgreSQL Berlin September Meetup. Divyendu Singh and Marko Coha presented talks.
Brandur Leach: Postgres 18: OLD and NEW Rows in the RETURNING Clause
Postgres 18 was released today. Well down page from headline features like async I/O and UUIDv7 support, we get this nice little improvement:
This release adds the capability to access both the previous (OLD) and current (NEW) values in the RETURNING clause for INSERT, UPDATE, DELETE and MERGE commands.
It's not a showstopper the way async I/O is, but it is one of those small features that's invaluable in the right situation.
Jimmy Angelakos: PGDay Lowlands 2025 and Getting Postgres to the Next Level
I recently attended PGDay Lowlands 2025, an awesome PostgreSQL Community Event which took place on September 12th in the wondrous environment of the Rotterdam Zoo. It was a fantastic and focused day of PostgreSQL content, made all the more memorable by being in the company of amazing fish, sea turtles, and penguins!
Andrew Atkinson: What are SLRUs and Multixacts in Postgres? What can go wrong?
In this post we’ll cover two types of Postgres internals.
The first internal item is an “SLRU.” The acronym stands for “simple least recently used.” The LRU portion refers to caches and how they work, and SLRUs in Postgres are a collection of these caches.
Hans-Juergen Schoenig: PostgreSQL: "UPDATE … RETURNING" made even better
PostgreSQL 18 offers a couple of new features such as asynchronous I/O (aio), improvements around indexing, and a lot more. However, there is one feature that has really caught my attention. While it might go unnoticed by many users, it is really powerful and, to me, somehow represents everything I like about PostgreSQL.
The improvement I want to focus on today is related to the way the "RETURNING-clause" works in PostgreSQL 18.
Pavel Luzanov: PostgreSQL 18: part 5 or CommitFest 2025-03
September 25th marks the release of PostgreSQL 18. This article covers the March CommitFest and concludes the series covering the new features of the upcoming update. This article turned out quite large, as the last March CommitFest is traditionally the biggest and richest in new features.
Tomas Vondra: Tuning AIO in PostgreSQL 18
PostgreSQL 18 was stamped earlier this week, and as usual there’s a lot of improvements. One of the big architectural changes is asynchronous I/O (AIO), allowing asynchronous scheduling of I/O, giving the database more control and better utilizing the storage.
Amit Kapila: Parallel Apply of Large Transactions
Ian Barwick: PgPedia Week, 2025-09-14
Álvaro Herrera: Changes to NOT NULL in Postgres 18
After a very long development period, we finally completed the project to rework NOT NULL constraints in PostgreSQL. This has long been a desire of the Postgres development community, and we finally pulled it off for version 18, which has made me very happy.
Elizabeth Garrett Christensen: Postgres’ Original Project Goals: The Creators Totally Nailed It
I had a chance last week to sit down and read the original academic paper announcing Postgres as a platform and the original design goals from 1986. I was just awestruck at the forethought - and how the original project goals laid the foundation for the database that seems to be taking over the world right now.
The PostgreSQL creators totally nailed it. They laid out a flexible framework for a variety of business use cases that would eventually become the most popular database 30 years later.
Cornelia Biacsics: PostgreSQL at the Zoo – My PGDay Lowlands 2025 Recap
Summer is slowly fading, and that means one thing: the PostgreSQL conference season in Europe is officially back. After PGDay Austria on September 4 and PGDay UK on September 9, the next stop was PGDay Lowlands in Rotterdam on September 12. Three conferences in such a short time is a clear sign that the community is back in full swing after the summer break.
warda bibi: Understanding PostgreSQL WAL and optimizing it with a dedicated disk
If you manage a PostgreSQL database with heavy write activity, one of the most important components to understand is the Write-Ahead Log (WAL). WAL is the foundation of PostgreSQL’s durability and crash recovery as it records every change before it’s applied to the main data files. But because WAL writes are synchronous and frequent, they can also become a serious performance bottleneck when they share the same disk with regular data I/O.
