PostgreSQL: Cleaning Up After Recent Features

Today's commits are mostly follow-up fixes for recently added features—logical decoding status, exclusion constraints on partitions, and read-only replication workers—showing the pattern of hardening new functionality shortly after it lands.

Duration: PT2M36S

Episode overview

This episode is a short developer briefing from PostgreSQL.

It explains recent repository work in plain language.

  • Show: PostgreSQL
  • Published: 2026-07-21T13:04:39Z
  • Audio duration: PT2M36S

Transcript excerpt

This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.

Good day, and welcome to the PostgreSQL briefing for July 21st, 2026.

The clearest pattern today: several commits are patching gaps in features that only recently shipped. This is normal, healthy follow-through, but it's worth tracking if you're working near these areas.

First, logical decoding status. Masahiko Sawada's commit 99e949f adds a logical decoding column to the pg control checkpoint SQL function, matching what was already added to the pg control data output. The earlier commit covered one reporting path but missed this one—a reminder that when you expose new state, check…

Second, partitioned tables continue to reveal edge cases as exclusion constraints get more use. Álvaro Herrera's commit d049a31, with a fix from Japin Li, addresses a restore failure for partitions with exclusion constraints, tightening how index comparisons are done. Separately, Michael Paquier's commit fc6425f…

Third, logical replication workers and read-only settings. Amit Kapila's commit d774576 fixes a failure where sequence synchronization workers couldn't run if the subscriber had default transaction read-only enabled. The fix now overrides that setting uniformly for all logical replication…

A few…

Nearby episodes from PostgreSQL

  1. Closing the Gaps Between Correctness and Convention
  2. Weekly Recap - Correctness Fixes and Late-Beta Caution
  3. Five Bug Fixes, One Pattern of Care in Correctness
  4. Late-Beta Cleanup and Correctness Fixes
  5. Silent Corruption, Loud Fixes
  6. Visibility Map Bug Fixed, Old Baggage Dropped
  7. I/O Return Types and JSON_TABLE Cleanup
  8. Cleaning Up the Codebase's Foundations