PGNexus Daily News

Bharath Rupireddy reports that `REPACK (CONCURRENTLY)` produces a misleading "no identity index" error when run against a materialized view. A patch is proposed that adds a proper…

A crash was reported by Tender Wang (found via SQLSmith) after commit 2ebf25e7d70a8, which was part of the `remove_useless_joins` fix for bug #19560. The crash occurs when a subqu…

The thread discusses a patch proposal to randomize B-Tree page split locations in PostgreSQL's nbtree code to reduce oscillating split patterns. Andrey Borodin supports restrictin…

The thread discusses a structural issue with `pg_subscription`, a shared catalog that contains database-specific OIDs, causing problems with `REASSIGN OWNED` and dependency tracki…

The thread discusses bugs in PostgreSQL 19's FK fast-path batching layer. Amit Langote previously fixed an out-of-bounds write and missed FK checks, keying the cache by (constrain…

Alexander Lakhin confirmed that Daniel Gustafsson's proposed fix—changing `disable_data_checksums($node)` to `disable_data_checksums($node, wait => 1)`—resolves a timing-related t…