PostgreSQL: Performance Optimizations and Better Backup Tools
Today's PostgreSQL development brings significant performance improvements with Tom Lane's PL/pgSQL SELECT optimization that speeds up common database operations, plus major enhancements to backup tooling. The team also improved transaction wraparound warnings and added new JSON formatting options for the COPY command.
Duration: PT4M33S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-03-21T10:04:14Z
- Audio duration: PT4M33S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Hey there, PostgreSQL enthusiasts! Welcome back to another episode of the PostgreSQL podcast. I'm thrilled you're here with me today because we've got some really exciting developments to dive into from March 21st, 2026. Grab your favorite beverage and let's talk about some changes that are going to make your…
So today we're looking at 16 commits with no merged pull requests, but don't let that fool you - these standalone commits are packed with goodness. The PostgreSQL team has been busy optimizing performance, improving backup tools, and making the developer experience smoother all around.
Let's start with the star of the show - Tom Lane has delivered what I'm calling a "stealth performance boost" for PL/pgSQL. You know how sometimes you write `SELECT some_expression INTO my_variable` instead of `my_variable := some_expression`? Maybe you're coming from SQL Server or you just think it reads better?…
Now, if you're dealing with backups and WAL files, Andrew Dunstan and the team have some fantastic news. They've completely revolutionized how pg_waldump works by adding support for reading WAL files directly from tar archives. This might sound technical, but here's why it matters: if…
T…