Greg Sabino Mullane
Greg Sabino Mullane
In a recent Postgres patch authored by Greg Sabino Mullane, Postgres has a new step forward for data integrity: data checksums are now enabled by default. This appears in the release notes as a fairly minor change but it significantly boosts the defense against one of the sneakiest problems in data management - silent data corruption. Let’s dive into what this feature is, what the new default means for you, and how it impacts upgrades. A data checksum is a simple but powerful technique to ver...
Read MoreBrandur Leach
Brandur Leach
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. A simple demonstration with to get all old and new values: Say w...
Read MoreElizabeth Christensen
Elizabeth Christensen
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....
Read MoreElizabeth ChristensenDavid Christensen
Elizabeth ChristensenDavid Christensen
UPDATE : Postgres 19 builds on several themes here—async I/O worker autoscaling, , and B-tree skip scan—plus more resilient , LZ4 as the default toast compressor, and smoother partition operations. For how those changes affect earlier Crunchy advice on load, storage, indexes, and partitioning, see Postgres 19: How Our Advice Has Changed Since We Wrote It . Postgres 18 will be released in just a couple weeks! Here’s some details on the most important and exciting features. Postgres 18 is addin...
Read More