PostgreSQL: Lock Statistics Revolution

PostgreSQL just got a massive upgrade to its monitoring capabilities with the introduction of comprehensive lock statistics tracking. Michael Paquier and Bertrand Drouvot delivered a game-changing feature that gives developers unprecedented visibility into lock behavior, plus important security improvements to password handling and documentation enhancements.

Duration: PT4M11S

Episode overview

This episode is a short developer briefing from PostgreSQL.

It explains recent repository work in plain language.

  • Show: PostgreSQL
  • Published: 2026-03-24T10:02:03Z
  • Audio duration: PT4M11S

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 code crafters! Welcome back to another episode of the PostgreSQL podcast. I'm absolutely buzzing with excitement today because we just witnessed something pretty spectacular in the PostgreSQL world. Grab your favorite beverage because we're diving into some seriously cool database internals.

So here's the thing - have you ever been debugging a performance issue and wished you could peek inside PostgreSQL's lock system to see what's really happening? Well, your wishes just came true! The star of today's show is a absolutely brilliant contribution from Bertrand Drouvot, with Michael Paquier providing the…

Let me paint you a picture of what this means. Previously, when your queries were running slower than molasses, you'd be squinting at pg_locks and making educated guesses about lock contention. Now? Now you get a beautiful new view called pg_stat_lock that tells you exactly what's happening. We're talking about…

What I love about this implementation is how thoughtfully it's designed. The team made sure this doesn't impact performance-critical code paths - because the last thing you want is your monitoring tools slowing down your database, right? They're only…

But…

I…

Nearby episodes from PostgreSQL

  1. Buffer Management Revolution - Async I/O Gets Smarter
  2. Query Planning Gets Smarter
  3. Base32hex Encoding and Code Quality Cleanup
  4. The Great WAL Record Cleanup
  5. Performance and Quality Improvements
  6. Testing the Hidden Heroes
  7. Performance Optimizations and Better Backup Tools
  8. Performance Breakthroughs and Developer Experience Wins