PostgreSQL: The LZ4 Compression Dance
Today we're diving into PostgreSQL's journey with LZ4 compression as the new default for TOAST data - including a fascinating revert and retry story. We'll also explore improvements to pg_restore, hash join optimizations, and several important bug fixes that show the continuous polish happening in the PostgreSQL ecosystem.
Duration: PT4M9S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-03-05T11:03:40Z
- Audio duration: PT4M9S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Hey there, fellow developers! Welcome back to another episode of the PostgreSQL podcast. It's March 5th, 2026, and I'm here with my virtual coffee mug, ready to dive into some really interesting changes happening in the PostgreSQL world.
You know, sometimes the most fascinating stories in software development aren't about the features that land perfectly - they're about the journey to get there. And today's main story is exactly that kind of tale.
Let's talk about what I'm calling "the LZ4 compression dance." Michael Paquier and the team have been working on changing the default compression algorithm for TOAST data from the older pglz to LZ4. Now, if you're not familiar with TOAST - that's PostgreSQL's way of handling large data that doesn't fit nicely in…
Here's where it gets interesting. The team initially tried to make LZ4 a hard requirement for all builds, but the PostgreSQL buildfarm - that's their continuous integration system - absolutely hated it. Over 60% of the build machines didn't have LZ4 installed! So they had to revert the change mid-stream.
But here's what I love about this story - they didn't give up. Michael came back with a more elegant approach. Instead of…
This…
Nearby episodes from PostgreSQL
- Optimizing the Engine from the Inside Out
- When Booleans Go Wrong
- Major Auth Upgrade and Subscription Revolution
- Monitoring Gets a Major Upgrade
- Publishing Power-Up and Performance Gains
- Fixing the Little Things That Matter
- Code Clarity and Speed Wins
- Switch Case Safety and Background Worker Improvements