PGNexus Daily News PostgreSQL Technical Articles [image: Hacking Workshop for September 2026] <https://pgnexus.ai/tech-blogs?url=http%3A%2F%2Frhaas.blogspot.com%2F2026%2F0...> rhaas.blogspot.com Hacking Workshop for September 2026 <https://pgnexus.ai/tech-blogs?url=http%3A%2F%2Frhaas.blogspot.com%2F2026%2F0...> Robert Haas announces a PostgreSQL hacking workshop scheduled for September 2026, featuring David Rowley as guest speaker. Rowley will present on optimizing code in performance-cr… Read the Blog <https://pgnexus.ai/tech-blogs?url=http%3A%2F%2Frhaas.blogspot.com%2F2026%2F0...> [image: plRuby] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> www.postgresql.org plRuby <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> plRuby is a new PostgreSQL procedural language extension that allows database functions to be written in Ruby. It embeds an MRI Ruby 3.x interpreter directly in the PostgreSQL bac… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> PostgreSQL Hackers Email Discussion Highlights WAL compression setting after PostgreSQL LZ4 default change <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%20...> The discussion focuses on changing the behavior of `wal_compression = 'on'` in PostgreSQL 19 so that it maps to lz4 (when available) instead of always using pglz. The goal is to a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%20...> pg19b1: TRAP: failed Assert("pgstat_bktype_io_stats_valid(bktype_shstats, MyBackendType)") <https://pgnexus.ai/hacker-discussions?subject=pg19b1%3A%20TRAP%3A%20failed%2...> A failed assertion in `pgstat_bktype_io_stats_valid()` was triggered when non-zero IO time was recorded with a zero operation count, specifically for "foreign IO" waits in `WaitRe… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg19b1%3A%20TRAP%3A%20failed%2...> pgstat: Flush some statistics within running transactions, take 2 <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20sta...> Sami Imseih posted v2 of a patch enabling mid-transaction pgstat flushes. Bertrand Drouvot reviewed it and identified three issues: (1) calling pgstat_report_stat() mid-transactio… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20sta...> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> Tomas Vondra and Matheus Alcantara continue iterating on Bloom filter pushdown for hash joins. Matheus posted v9, incorporating six prior changes plus a key new fix: replacing `bl… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> walsummarizer can get stuck when switching timelines <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20st...> Robert Haas has committed and back-patched a fix for an issue where the walsummarizer can get stuck when switching timelines. The patch went through at least three versions (v3 be… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20st...> CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc. <https://pgnexus.ai/hacker-discussions?subject=CREATE%20SUBSCRIPTION%20...%20...> Jeff Davis posted a consolidated patch series addressing how CREATE SUBSCRIPTION handles connections, validation, and compatibility with pg_dump/restore. Key changes include: form… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=CREATE%20SUBSCRIPTION%20...%20...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-31-postgresql-daily-news-224.m...> Industry News [image: Anthropic says its own AI models breached three companies during security tests] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Anthropic says its own AI models breached three companies during security tests <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Anthropic has disclosed that its own AI models breached three companies during internal security tests. The revelation came after OpenAI's models reportedly broke into Hugging Fac… [image: Google nixes its Earth AI feature one day after launch amid misinformation criticism] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Google nixes its Earth AI feature one day after launch amid misinformation criticism <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Google pulled its Earth AI feature just one day after launch following swift public backlash. The tool allowed users to generate AI-created imagery and superimpose it over real Go… [image: Siri AI could come with a paywall for power users via iCloud+] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Siri AI could come with a paywall for power users via iCloud+ <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Apple CEO Tim Cook has indicated that advanced Siri AI capabilities could become a paid feature for power users, integrated into the company's existing iCloud+ subscription tiers.… Social Media Updates linkedin Not every AI task deserves the same resources. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Unity AI Gateway allows organizations to route AI workloads based on their value and priority. Low-value tasks can be directed to cost-efficient open-source models, while high-val… linkedin AI is changing what data teams are expected to build. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> DataExpert.io founder Zach Wilson is launching a free six-hour Databricks boot camp starting August 3, aimed at data professionals adapting to AI-driven expectations. The curricul… linkedin 🕹️ Ubisoft needed to get game data to developers, designers, and applications faster. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Ubisoft struggled with slow data access due to a legacy Hadoop environment, fragmented tooling, and SQL-dependent workflows, leaving some teams waiting days for answers. By adopti… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more