Statistics Revolution and Performance Polish
Today brings major enhancements to PostgreSQL's statistics system with new extended stats restoration functions, plus some solid performance optimizations and code cleanup. Michael Paquier and team deliver powerful new tools for database migrations, while David Rowley squeezes out extra performance from sequential scans.
Duration: PT4M35S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-01-26T11:09:27Z
- Audio duration: PT4M35S
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 your host, and wow, do we have some exciting developments to dive into today - January 26th, 2026. Grab your favorite beverage because we're about to explore some really cool improvements that landed in the codebase.
Let me start with the star of today's show - a fantastic new feature that's going to make database administrators everywhere smile. Michael Paquier, working with Corey Huinker and reviewed by Chao Li, has introduced something called `pg_restore_extended_stats()`. Now, I know that might sound a bit technical, but…
Think about this scenario: you're upgrading your PostgreSQL cluster or doing a major dump and restore operation. Traditionally, after you restore your data, you'd have to run ANALYZE to rebuild all those important statistics that help PostgreSQL make smart decisions about how to execute your queries. That takes time…
Well, this new function changes that game completely. It's like having a time machine for your database statistics. You can now restore extended statistics directly - things like n_distinct values that tell PostgreSQL how many unique values are in…
What…
…
Nearby episodes from PostgreSQL
- Cleaning House and Building Better Foundations
- Polish Week - Eight Quality Commits Clean Up the Codebase
- Statistics Revolution and Code Cleanup
- Backup & Performance Polish Party
- Database Reliability Deep Dive
- Protocol Prep and Memory Math Fixes
- Error Messages, Testing Love, and C++ Bridges
- Bug Hunting Season in PostgreSQL