Databases and Infrastructure: 2026-10-12

PostgreSQL hackers led the day with active patch review on logical decoding, replication conflict logging, backup verification, and WAL preallocation, while policy talk turned to abandoned extensions. QEMU series advanced TargetInfo handling, aarch64 KVM host models, and VFIO dmabuf support for virtio-gpu.

Logical decoding bug with DDL and subtransactions

PostgreSQL developers are reviewing version 5 of a patch for bug 19555, an assert failure in logical decoding when DDL meets subtransactions and tuplecid handling. The fix is under discussion for backport to all stable branches. Operators who depend on logical replication have a direct interest in seeing the correction land cleanly.

Conflict log history table for logical replication

Hackers on pgsql-hackers continue iterating on patches that would add a conflict log history table for logical replication. The thread has drawn more than a hundred messages from a sizable group of participants. Better retained history of conflicts would give operators clearer diagnostics when replication diverges.

Detection of truncated compressed backups

A patchset corrects pg_verifybackup so it detects truncated backups compressed with zstd, gzip, or lz4. Reviewers are examining the changes and accompanying tests. Reliable verification of compressed base backups remains essential for anyone treating backups as recoverable.

Policy for abandoned extensions

The PGXN maintainer asked for a policy on abandoned extensions after security reports surfaced. Discussion weighs ownership transfer, forking, and end-of-life marking. Extension authors and downstream users both need clearer rules for unmaintained code.

TargetInfo passed to QOM is_available

A QEMU series refactors QOM so the is_available callback receives TargetInfo. The change supports multi-target combined binaries. It affects how availability checks behave across architectures in QEMU builds.

pg_wal_preallocate SQL function

A patch proposes a superuser function pg_wal_preallocate() that eagerly creates future WAL segments. Review covers the interface, caps linked to max_wal_size, and whether automatic alternatives would be better. Write-heavy deployments may gain more predictable latency if preallocation becomes available.

Customizable aarch64 KVM host model

Version 10 of a KVM/arm series adds writable ID register field properties to the host vCPU model. The work aims at greater migration flexibility for aarch64 guests. Sites running nested or migrating ARM virtual machines should track the series.

VFIO dmabuf from multiple ranges for virtio-gpu

Version 13 of a QEMU series creates dmabufs from multiple VFIO ranges and wires them into virtio-gpu. The feature supports blobs backed by device memory. It matters for graphics passthrough and device-memory sharing in virtualized setups.