PostgreSQL tablespace and replication fixes, QEMU ARM and USB work

PostgreSQL hackers advanced fixes for index corruption on tablespace rollback and several logical replication edge cases, along with upgrade and vacuum refinements. QEMU saw further revision of a large aarch64 KVM host model series and ASPEED USB controller support.

Index corruption after tablespace rollback

PostgreSQL hackers converged on a fix for BUG #19686, in which rolling back ALTER TABLE SET TABLESPACE inside a transaction could leave indexes corrupted. The defect touches transactional DDL and carries data integrity risk. Operators who move tables across tablespaces inside transactions have reason to track the resolution.

Apply worker crash on deferrable primary keys

A patch fixes an assertion crash in the logical replication apply worker when a subscriber table has only a deferrable primary key and lacks REPLICA IDENTITY FULL. Five participants discussed the change across twenty messages. The correction stabilizes apply for schemas that depend on deferrable constraints.

Customizable aarch64 KVM host model

Version 9 of a twenty six patch series adds SYSREG_* properties to QEMU's aarch64 KVM host model. The work supports writable ID registers and more flexible migration. Three participants drove the technical review on qemu-devel.

Conflict log history table for logical replication

Hackers reviewed version 77 of patches that introduce a conflict log history table for logical replication. Discussion centered on tuple size limits and JSON serialization edge cases. Eleven participants exchanged eighty three messages refining the design.

pg_upgrade handling of invalid databases

A proposal teaches pg_upgrade to skip invalid databases left by an interrupted DROP DATABASE instead of failing. Six participants examined the behavior. The change would make major version upgrades more tolerant of partial catalog cleanup.

Replacing unnecessary spinlocks

A patch proposes replacing many spinlock pairs with memory barriers for scalar accesses in PostgreSQL. Core developers warned that mechanical substitution can introduce subtle concurrency bugs. Four participants debated the safety tradeoffs.

Parallel autovacuum cost delay timing

A small patch propagates the track_cost_delay_timing GUC to parallel autovacuum workers. Review was positive, with minor revisions and a suggested backpatch to version 19. Five participants handled the thirteen message thread.

AST1030 USB device controller in QEMU

Version 2 of an eleven patch series adds AST1030 UDC support and fixes to QEMU's existing ASPEED UDC model. A single author posted the series. The work extends USB device controller emulation for ASPEED based boards.