PostgreSQL: Performance Week - Smart Domains & Lightning-Fast Indexes

This week brought major performance wins to PostgreSQL with 10 commits focusing on speed optimizations. Key highlights include enabling fast defaults for domain constraints (avoiding costly table rewrites), nbtree index optimizations that eliminate unnecessary memory allocations, and the introduction of a new pg_plan_advice module for query plan control.

Duration: PT4M15S

Episode overview

This episode is a short developer briefing from PostgreSQL.

It explains recent repository work in plain language.

  • Show: PostgreSQL
  • Published: 2026-03-13T10:02:10Z
  • Audio duration: PT4M15S

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 an exciting week to talk about! March 13th brought us 10 fantastic commits that are all about making PostgreSQL faster and smarter.

Let me start with what I think is the most user-facing win of the week. Jian He, with reviews from Tom Lane and Andrew Dunstan, delivered something that's going to make database administrators everywhere smile. You know how adding a column with a domain constraint used to force a full table rewrite, even when the…

The team implemented smart evaluation using PostgreSQL's soft error handling. Now when you add a column with a domain constraint, the system actually tests whether your default value passes those constraints at ALTER TABLE time. If it does - and it usually will - you get a fast default with no table rewrite needed.…

But wait, there's more performance goodness! Peter Geoghegan has been on a mission to make nbtree indexes lightning fast. This week he tackled something that might sound technical but has real-world impact - he eliminated unnecessary memory allocations during index scans. The old code was allocating a…

Spea…

Nearby episodes from PostgreSQL

  1. Security Gets Smarter with SNI Support
  2. SQL Property Graphs Land with a Bang
  3. Foundation Fixes and Platform Polish
  4. Performance Revolution - SIMD Powers and Index Optimizations
  5. Query Optimizer Gets Smarter with NOT IN Magic
  6. The REPACK Revolution
  7. Optimizing the Engine from the Inside Out
  8. When Booleans Go Wrong