PostgreSQL: Tightening Up Input Handling and Storage Defaults
Today's commits center on stricter, more consistent parsing and smarter defaults, from a shared LSN parser used across command-line tools to a new default WAL compression algorithm, alongside several correctness fixes in statistics tracking, table access methods, and test infrastructure.
Duration: PT2M43S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-08-12T13:04:05Z
- Audio duration: PT2M43S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
This is PostgreSQL, your developer briefing for August 12th, 2026.
The clearest theme today: consistency and correctness in how the system parses input and chooses defaults, work that mostly happens behind the scenes but changes real behavior.
First, input parsing. Commit d6bf0ab introduces a single, shared LSN parser used by pg_waldump, pg_recvlogical, and pg_receivewal. Previously these tools used a loose sscanf pattern that could accept malformed WAL locations - overlong values, stray characters, even hex prefixes - and silently proceed with the wrong…
Second, defaults that better match reality. Commit 931c970 changes what wal_compression=on actually means. It used to map to pglz specifically. Now it picks zstd or lz4 if your build supports them, falling back to pglz only if neither is available. The reasoning is straightforward: most administrators turning on WAL…
Third, statistics architecture. Michael Paquier's commit 72a6dad splits index statistics out of relation statistics into their own dedicated stats kind. This shrinks the shared memory footprint per index and clarifies which counters actually apply to indexes versus tables. One side effect worth remembering:…
A few…
Nearby episodes from PostgreSQL
- Housekeeping and Code Clarity
- Cleanup, Correctness, and Retiring Old Interfaces
- Closing the Gaps Between Related Commands
- Correctness Fixes Across Replication, Stats, and Tooling
- A Security Patch Batch Lands
- Correctness and Crypto Cleanup
- Weekly Recap - Correctness Fixes Under Concurrency and Crash Recovery
- Two Backpatched Fixes for v18