PostgreSQL corruption fixes and QEMU device work

PostgreSQL hackers focused on index and tuple corruption fixes plus logical replication and promotion reliability, while QEMU received series for Raspberry Pi networking and storage emulation. The day centered on data integrity patches and hardware model progress.

Index corruption after SET TABLESPACE rollback

PostgreSQL hackers converged on a fix for index corruption after rollback of ALTER TABLE SET TABLESPACE inside a transaction. The issue is tracked as BUG #19686 and drew 33 messages from seven participants. Operators who alter tablespaces transactionally should watch for the correction to avoid inconsistent indexes.

QEMU raspi4b PCIe and GENET networking

A v4 patch series adds a functional PCIe root complex and GENET Ethernet to the QEMU raspi4b machine, including MDIO and DMA implementations, migration state, tests, and documentation updates. The sixteen-message series was submitted by one participant. The work brings real networking to Raspberry Pi 4 emulation.

Missing tts_tid ctid corruption fix

A patch fixes missing tts_tid in ExecForceStoreHeapTuple, which caused ctid corruption, table extension, and invalid pages on FOR UPDATE after GiST KNN scans. Six participants discussed the seventeen-message thread on pgsql-hackers. The change prevents integrity failures on affected query paths.

Conflict log history for logical replication

PostgreSQL hackers continued active review and iteration on patches adding a conflict log history table for logical replication. Fourteen participants exchanged 131 messages on the proposal. The feature would improve debugging and observability of replication conflicts.

Promotion hang on blocked backend in PG19

A PostgreSQL 19 regression causes promotion to hang behind a backend blocked on a stuck client, waiting on ProcSignalBarrier even with replica wal_level. A patch series addresses blocked I/O and unnecessary waits across fourteen messages from five participants. Standby operators should note the forthcoming resolution.

Direct TOAST v2 addressing

A v2 patch proposes direct TID addressing for TOAST tuples to cut index lookups and write amplification, aiming for faster and smaller storage without migration. Seven participants discussed the thirty-one-message thread. The design targets lower overhead for large attribute handling.

IOThread holder tracking in QEMU

Version 18 of a QEMU patch series adds holder tracking and query support to IOThreads, converting users to new reference APIs for better observability. One participant submitted the fifteen-message series. The change improves visibility into IOThread ownership.

Zoned UFS emulation in QEMU

A v2 patch series adds host-managed zoned emulation to QEMU's UFS device model, with prerequisite fixes and tests. Two participants contributed eleven messages. The work extends storage options for zoned devices under emulation.