PostgreSQL index regression and QEMU arch emulation

PostgreSQL hackers worked a JSON_ARRAY expression index regression and several correctness and tooling patches. QEMU developers advanced large series for Arm MPAM emulation, RISC-V packed SIMD support, and virt device security marking.

PostgreSQL JSON_ARRAY expression indexes go stale

A regression in PostgreSQL 19 lets JSON_ARRAY() expression indexes go stale after ALTER TYPE or output setting changes. Patches were proposed on pgsql-hackers to correct the behavior. Operators who rely on expression indexes over JSON data have a concrete reason to track the fix before upgrading.

QEMU Arm MPAM 1.1 emulation

A 37-patch series on qemu-devel adds Arm MPAM 1.1 register and MSC emulation to the QEMU virt machine. The goal is Linux resctrl support in that environment. Developers testing memory system partitioning on Arm virtual platforms gain a fuller model.

QEMU RISC-V P extension support

A v3 series of 19 patches adds full emulation for the RISC-V P (packed SIMD) extension to QEMU, along with tests. Discussion on qemu-devel involved two participants. RISC-V work that needs packed SIMD coverage under simulation depends on this landing.

PostgreSQL IMPLIES boolean operator

A patch on pgsql-hackers adds an IMPLIES boolean operator that is right-associative and maps to NOT a OR b. Thread traffic covered associativity, NULL handling, and precedence among seven participants. SQL authors who want explicit implication syntax should watch how the design settles.

pgindent checks in PostgreSQL CI

Developers proposed running pgindent and whitespace checks in Postgres CI as non-fatal warnings, after related exclude and build fixes. Eight participants discussed the change on pgsql-hackers. The change aims to surface formatting drift earlier without failing builds.

Base backup races on non-relation files

A patch aims to stop base backup corruption of non-relation files such as auto.conf, twophase, and replorigin that can arise from stat and rename races. Five participants worked the topic on pgsql-hackers. Sites that depend on physical backups have a direct stake in the fix.

EXPLAIN buffer access strategies

A patch series proposes exposing buffer access strategies (normal, bulkread, and related modes) through EXPLAIN (ANALYZE, BUFFERS). Four participants discussed it on pgsql-hackers. Query tuners get clearer evidence of which strategy the system actually used.

QEMU secure marking for virt devices

A v2 series of 28 patches marks user-creatable devices relevant to virt as secure for security boundary classification. Three participants exchanged a long thread on qemu-devel. The work clarifies which devices fit inside secure virt configurations.