Neues vom PostgreSQL Planet
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.
Stefanie Janine Stölting: pgsql_tweaks Version 1.0.1 Released
-
pgsql_tweaks is a bundle of functions and views for PostgreSQL
-
Stefanie Janine Stölting: pgsql_tweaks Version 1.0.2 Released
-
pgsql_tweaks is a bundle of functions and views for PostgreSQL
-
Luca Ferrari: pgenv 1.4.3 is out!
A new minor release for the beloved tool to build and manage multiple PostgreSQL instances.
pgenv 1.4.3 is out!pgenv 1.4.3 is out! This minor release fixes a problem in the build of release candidate versions (e.g., 18rc1) by stripping out all the text part from a version number using a Bash regular expression.
-
Daniel Vérité: What Unicode versions do we use?
With three locale providers (libc, icu and builtin), a PostgreSQL instance has potentially three different versions of Unicode at the same time. In this post, let's see when it matters and how to find which Unicode versions we are using.Karen Jex: Postgres Partitioning Best Practices: Sofia's Story
Thank you to everyone who came to listen to my talk, "Postgres Partitioning Best Practices", at Euruko in Viana do Castelo, Portugal on 18 September 2025.
Thank you for all the questions and conversations, and thank you, especially, to the real-life Sofia - the person who found me to say
"Your talk described exactly what I went through, and I wish I'd been able to watch a talk like this before I started."
Hans-Juergen Schoenig: PostgreSQL 18: Better I/O performance with AIO
PostgreSQL 18 is around the corner and it is time to take a look at one of the most important improvements that have been added to the core engine. We are of course talking about the introduction of asynchronous I/O (AIO), which has been a huge topic over the years.
Synchronous vs. asynchronous I/OLet's dive into this and understand what the fuzz is all about. The standard I/O model works roughly like this:
Pavlo Golub: pgwatch v4-beta is out!
pgwatch v4? Yes, after a long time of silence, we are finally releasing a new major version!
Why version 4?What happened to pgwatch v3!? It was released less than a year ago!
If Firefox can have version 142 and Chrome version 139 (and those numbers are probably already outdated by the time of publishing), why should we care about strict versioning? 🙂
On a more serious note, we decided to stick to the PostgreSQL major versioning scheme, so pgwatch major releases will now follow PostgreSQL major releases.
Henrietta Dombrovskaya: September PUG recording
I am glad we had an option to replay this talk from PG Day Chicago one more time! If you didn’t have a chance to join us, here is the recording – enjoy!
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Add date and timestamp variants of random(min, max).
On 9th of September 2025, Dean Rasheed committed patch: Add date and timestamp variants of random(min, max).Paul Ramsey: 2025 PostGIS & GEOS Release
I am excited to announce PostGIS 3.6 and GEOS 3.14.
The PostGIS spatial extension to PostgreSQL and the GEOS computational geometry library taken together provide much of the functionality of PostGIS, and are the open source focus of the (Crunchy Data) Snowflake PostGIS team.
Esther Minano: Making Postgres scale to zero with CNPG
How we built activity-aware Postgres clusters that hibernate automatically and save resourcesFloor Drees: Contributions for the week 37
Miles Richardson presented the WarehousePG project (an open source Greenplum fork) at the Apache Iceberg™ Europe Community Meetup in London, September 8. Watch the recording: youtu.be/lz6w9W1Ubps?si=upETJvoKD_zuHL0R
PGDay UK took place, September 9, at the Cavendish Conference Center.
Organizers:
- Chris Ellis
- Devrim Gunduz
- Dave Page
Talk Selection Committee:
Ants Aasma: Reconsidering the interface
Recently a great presentation “1000x: The Power of an Interface for Performance” from Joran Dirk Greef from TigerBeetle made the rounds. If I may summarize, the gist of the presentation was that the correct programming model can mean many orders of magnitude performance difference. As the presentation did not explore this, I wanted to see how far we get by adjusting our programming style on boring old relational databases.
Seiten
-
pgsql_tweaks is a bundle of functions and views for PostgreSQL
-
