Postgres feature debates and QEMU virtualization work

PostgreSQL hackers debated reverting complex post-freeze features after elevated bug counts, while QEMU developers advanced nested virtualization and single-binary build patches.

Postgres hackers debate reverting PG19 features

Hackers on pgsql-hackers discussed whether to revert three complex PostgreSQL 19 features: RI foreign key batching, REPACK CONCURRENTLY, and online checksums. The heated exchange followed high post-freeze bug counts identified via LLM analysis. The outcome affects release stability for users tracking upcoming major-version readiness.

QEMU implements LVZ support for LoongArch TCG

A 14-patch series adds LVZ guest support to the LoongArch TCG target in QEMU, enabling nested virtualization. Two participants refined the proposal across 17 messages. The work expands open source emulation options for LoongArch hardware with nested guests.

Logical replication row filter nulls toasted columns

A bug report showed that logical replication row filters turn unchanged toasted columns into NULL on the subscriber. Eight participants on pgsql-hackers examined a fix in 30 messages. Reliable handling of large values is essential for correct replication of production data.

Dynamic QOM filtering for QEMU single-binary builds

A 47-patch series introduces a TypeInfo callback for dynamic filtering of QOM types in multi-target single-binary QEMU builds. Three developers reviewed the changes in 50 messages. The approach simplifies builds that combine multiple architectures into one binary.

Conflict log history table for logical replication

Ongoing review of a patch to store logical replication conflicts in a history table uncovered buffer-size and replica-identity bugs. Nine participants exchanged 47 messages on pgsql-hackers. Better conflict visibility helps operators diagnose and resolve data divergence.

Secure SMMUv3 support in QEMU Arm model

An RFC v5 series of 28 patches adds Secure state support for SMMUv3 in the QEMU Arm hardware model. Four participants conducted active review across 72 messages. Secure IOMMU handling matters for trusted execution environments on Arm platforms.

Nix flake proposed for PostgreSQL development shells

A proposal to add flake.nix for Nix-based PostgreSQL development shells prompted core developers to question demand and scope. Six participants discussed the idea in 12 messages. Packaging choices shape how contributors obtain reproducible build environments.

WAIT FOR query jumbling for pg_stat_statements

A patch proposed normalizing LSN and option values in the WAIT FOR command so pg_stat_statements can track them via DefElem. Five participants reviewed the change in nine messages. Accurate statement statistics improve monitoring of queries that wait on LSNs.