2026-05-06 PostgreSQL News Digest

Commits

The day focused on important bug fixes and operational improvements, including WAIT FOR LSN cleanup, checksum worker throttling, and documentation for a deprecated backup verification option.


Fix WAIT FOR LSN cleanup on subtransaction abort

Alexander Korotkov (5cdec423)

This fixes cleanup during subtransaction aborts in WAIT FOR LSN. It resolves a case where an interrupt inside a SAVEPOINT could leave a backend marked in the WAIT FOR LSN heap.


Fix regex searching for page verification failures in tests

Daniel Gustafsson (486b9a9b)Discussion: CAHg+QDe

This fixes an incorrectly anchored regular expression used by tests that search log files for page verification failures. The change makes the tests behave more accurately.


Apply data-checksum worker throttling parameters

Daniel Gustafsson (9a39056c)

Data-checksum worker throttling parameters are now applied. This lets users control the I/O load caused by enabling checksums.


Skip WAL for unlogged main fork during online checksum enable

Daniel Gustafsson (2018bd61)

WAL is now skipped for unlogged main forks during online checksum enablement. This suppresses excessive WAL generation for unlogged relations.


Document deprecated --wal-directory option for pg_verifybackup

Peter Eisentraut (43dc21f7)Discussion: E1w3fZp-000gje-31@gemulon.postgresql.org

The deprecated --wal-directory option for pg_verifybackup has been added to the documentation. This helps users migrate smoothly across versions.


HN News

(No HN stories for this day)


Summary

PostgreSQL development today centered on important bug fixes and performance-related improvements. The WAIT FOR LSN subtransaction cleanup fix and data-checksum worker throttling changes should improve stability and operational control.


This digest was generated by gemini based on Hacker News, GitHub, and the PostgreSQL mailing list.