Neues vom PostgreSQL Planet

PostgreSQL 19 changes this week random(min, max) : date and timestamp variants added log_lock_waits now set to on by default ERRCODE_DATA_CORRUPTED error codes will be emitted if VM corruption is discovered during vacuum operations PostgreSQL 18 articles Get Excited About Postgres 18 (2025-09-12) - Elizabeth Garrett Christensen / Crunchy Data 3 Features I am Looking Forward to in PostgreSQL 18 (2025-09-09) - Umair Shahid / Stormatics

more...

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.

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.