PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Support for 8-byte TOAST values, round two <https://pgnexus.ai/hacker-discussions?subject=Support%20for%208-byte%20TOAST...> The discussion focuses on testing strategies for the 8-byte TOAST chunk_id feature. Bharath Rupireddy proposed a new test module in src/test/modules (similar to xid_wraparound) wi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Support%20for%208-byte%20TOAST...> Race conditions in logical decoding <https://pgnexus.ai/hacker-discussions?subject=Race%20conditions%20in%20logic...> Rui Zhao submitted patch v5-0004 to fix a bug in v5-0001 where `newxcnt++` was incorrectly placed outside the `test == NULL` branch, causing committed XIDs to increment the count… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Race%20conditions%20in%20logic...> pg_plan_advice: add NO_ scan and join method tags <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20add%20NO_%...> The discussion concerns the `pg_plan_advice` extension patch that adds `NO_` scan and join method tags. A contributor, shihao zhong, rebased the patch (v4) onto the current master… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20add%20NO_%...> remove_useless_joins vs. bug #19560 <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20b...> A regression introduced by commit e28cf96e935 ("Fix stale copies of PHVs in subqueries") was identified, where an upper-level PlaceHolderVar (PHV) containing an unprocessed SubLin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20b...> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> The discussion focuses on two planner optimizations—run conditions and frame rewriting—that were blocked for Row Pattern Recognition (RPR) windows in PostgreSQL. Henson Choi expla… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Social Media Updates linkedin CYBERTEC CEO Hans-Juergen Schoenig shares why AI isn't just another incremental upgrade, it's a fundamental shift that will reshape database engineering, system architecture, and enterprise technology as a whole. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> CYBERTEC CEO Hans-Juergen Schoenig argues that artificial intelligence represents more than an incremental technological improvement. In his view, AI is a fundamental shift poised… [image: 🔰 The Databricks Advanced Learning Festival runs September 16 through October 14, with learning pathways across data engineering, analytics, machine learning, generative AI, Apache Spark™, and data warehousing.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin 🔰 The Databricks Advanced Learning Festival runs September 16 through October 14, with learning pathways across data engineering, analytics, machine learning, generative AI, Apache Spark™, and data warehousing. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> The Databricks Advanced Learning Festival takes place from September 16 to October 14, offering structured learning pathways in data engineering, analytics, machine learning, gene… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more