PostgreSQL and QEMU infrastructure discussions

PostgreSQL hackers examined materialized view replacement, logical replication toast handling, backup verification, and WAL preallocation. QEMU developers advanced RISC-V confidential VMs, disassembler work, IOThread tracking, and Arm64 CPU models.

Materialized view replacement syntax

PostgreSQL core developers debated CREATE OR REPLACE versus ALTER for changing materialized view queries. The exchange focuses on whether data and indexes should be preserved across the operation. The eventual choice will affect operators who refresh large views without rebuilding them from scratch.

RISC-V CoVE confidential VMs in QEMU

An RFC series proposes QEMU KVM support for RISC-V CoVE confidential virtual machines. The design is modeled on existing SEV and TDX paths. The work extends confidential computing options for RISC-V guests under KVM.

Logical replication toast column bug

Hackers discussed a bug in which logical replication row filters turn unchanged toasted columns into NULL on the subscriber. A fix is under review across multiple messages. Correct handling matters for replicas that filter rows containing large values.

Truncated compressed backup detection

A patchset corrects pg_verifybackup so it detects truncated zstd, gzip, and lz4 compressed backups. Review included test coverage for the failure modes. Reliable verification protects operators who rely on compressed backup streams.

RISC-V disassembler reorganization

Richard Henderson posted version 2 of a 52-patch series that reorganizes the QEMU RISC-V disassembler around pointers. The series prompted extended technical review. Cleaner disassembly code benefits RISC-V emulation and debugging work.

IOThread holder tracking

Version 12 of a series adds tracking of IOThread holders and exposes them through query-iothreads. The goal is improved observability for devices and exports. Operators gain a clearer view of which components hold IOThreads.

WAL segment preallocation function

A patch introduces the superuser function pg_wal_preallocate() to create future WAL segments eagerly. Discussion covered interface details, limits via max_wal_size, and automatic alternatives. The feature can reduce latency spikes from on-demand segment creation.

Named Arm64 CPU models for KVM

RFC version 3 proposes named Arm64 CPU models for KVM to support cross-host live migration. Review concentrated on build fixes and the QMP command rationale. Stable named models improve migration across heterogeneous Arm hosts.