PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights REPACK (CONCURRENTLY) fails with wrong error for materialized views <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fail...> 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… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fail...> remove_useless_joins vs. bug #19560 <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20b...> 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… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20b...> Randomize B-Tree page split location to avoid oscillating patterns <https://pgnexus.ai/hacker-discussions?subject=Randomize%20B-Tree%20page%20sp...> 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… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Randomize%20B-Tree%20page%20sp...> REASSIGN OWNED vs. relisshared dep on !relisshared <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20relis...> 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… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20relis...> PG19 FK fast path: OOB write and missed FK checks during batched <https://pgnexus.ai/hacker-discussions?subject=PG19%20FK%20fast%20path%3A%20O...> 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… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=PG19%20FK%20fast%20path%3A%20O...> Changing the state of data checksums in a running cluster <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%20...> 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… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%20...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-29-postgresql-daily-news-253.m...> Social Media Updates linkedin Genie is changing how teams get answers from their data. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> In a DataFramed conversation, Databricks Co-Founder and Chief Architect Reynold Xin discusses how Genie is transforming how teams query and explore data. He explains how he person… linkedin GLM 5.3 is available as a day 0 release on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> GLM 5.3 is now available on Databricks as a day-zero release, positioned as the most capable open-weight model currently available. It joins GLM 5.3 Flash and over 30 open-source… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more