Postgres index regressions and replication work

PostgreSQL hackers focused on index correctness, DDL tooling, and replication edge cases, while Samba and QEMU advanced dependency and emulation changes. The day mixed regression fixes with longer-running design debates.

JSON_ARRAY expression indexes go stale in PG19

A regression introduced in commit ecd9288624a lets PostgreSQL 19 JSON_ARRAY() expression indexes become stale after ALTER TYPE or output setting changes. Patches were proposed on pgsql-hackers to restore correct invalidation. Operators relying on such indexes need the fix to keep query results consistent with underlying data.

Redesign debate for pg_get_*_ddl functions

Core hackers disputed whether to redesign or remove pg_get_role_ddl() over dependency ordering, password handling, and overlap with pg_dump. The heated exchange ran to 32 messages among 10 participants. Tooling that reconstructs role definitions from catalogs is directly affected by the outcome.

Conflict log history table for logical replication

Review continued on a proposed conflict log history table for PostgreSQL logical replication, covering error handling, GUCs, and edge cases. The thread reached 181 messages from 15 participants. The feature would give replication operators durable visibility into apply conflicts.

WAL statistics double-counting from parallel workers

A patch corrects double-counting of WAL generated by parallel workers in pg_stat_wal and EXPLAIN, a problem present since PostgreSQL 14. Five participants discussed the change. Accurate cumulative WAL figures matter for capacity planning and EXPLAIN-based analysis.

Subscription two_phase state reset on ALTER

A proposed fix stops ALTER SUBSCRIPTION from resetting the two_phase state to pending when it is already enabled. The existing behavior can break prepared-transaction checks. Seven developers examined the 18-message thread.

Samba weighs OpenSSL dependency

Samba developers discussed adding OpenSSL after its license change to enable GKDI support and replace the end-of-life hcrypto library. The single-participant thread evaluated build and cryptographic implications. The shift would alter Samba packaging and available crypto primitives.

Freescale Book E CPU model corrections in QEMU

Bin Meng posted a v2 17-patch series that corrects SPRs, caches, and ISA flags while adding TCG tests for Freescale Book E models in the QEMU PPC target. Two participants exchanged 20 messages. The updates improve emulation accuracy for embedded PowerPC systems.

Remote Port co-simulation protocol for QEMU

A v2 20-patch series introduces a Remote Port co-simulation framework under hw/core for SystemC and RTL integration. Four participants reviewed the proposal. The work supports tighter hardware-software co-simulation setups.