PostgreSQL: Statistics Revolution and Code Cleanup
Today's PostgreSQL episode dives into a major advancement in extended statistics with new MCV (most-common values) support in pg_restore_extended_stats(), plus important replication origin refactoring and query planner enhancements. We saw 14 commits focused on making PostgreSQL's statistics system more robust and its codebase cleaner, with standout contributions from Michael Paquier, Masahiko Sawada, and the community.
Duration: PT4M13S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-01-29T11:13:57Z
- Audio duration: PT4M13S
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 developers! Welcome back to another episode. I'm your host, and wow, do we have some exciting developments to talk about today. Grab your favorite beverage because we're diving into some really meaningful changes that landed in the PostgreSQL codebase.
So here's the thing - while we didn't see any merged pull requests today, we had 14 fantastic commits that tell a really compelling story about PostgreSQL's evolution. And honestly, sometimes these steady, focused improvements are exactly what makes a database system truly great.
Let's start with the star of the show - Michael Paquier and the team have delivered something pretty spectacular with extended statistics support. The big headline here is the addition of MCV - that's "most-common values" - support in pg_restore_extended_stats(). Now, this might sound technical, but here's why it…
What I love about this implementation is the thoughtful design. They're using three coordinated arrays - most_common_vals, most_common_freqs, and most_common_base_freqs - that work together like a well-choreographed dance. And get this - they even figured out how to rebuild the nulls information automatically, which…
Corey…
But…
Nearby episodes from PostgreSQL
- Upgrades Get Smarter
- Polish, Performance, and Developer Experience Wins
- Cleaning House and Building Better Foundations
- Polish Week - Eight Quality Commits Clean Up the Codebase
- Backup & Performance Polish Party
- Statistics Revolution and Performance Polish
- Database Reliability Deep Dive
- Protocol Prep and Memory Math Fixes