PGNexus Daily News PostgreSQL Technical Articles [image: powa-archivist 5.2.0 is out!] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> www.postgresql.org powa-archivist 5.2.0 is out! <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> powa-archivist 5.2.0 has been released by the PoWA team. This version adds support for PostgreSQL 19, including the new statistical views pg_stat_recovery and pg_stat_lock, contri… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> PostgreSQL Hackers Email Discussion Highlights Add pg_stat_vfdcache view for VFD cache statistics <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_vfdcache%20view%...> The thread discusses adding a `pg_stat_vfdcache` view to expose VFD (Virtual File Descriptor) cache statistics for tuning `max_files_per_process`. Key design questions include whe… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_vfdcache%20view%...> allow spread checkpoints when changing checksums online <https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%2...> The discussion concerns a patch to allow spread checkpoints during online checksum changes. Fujii Masao questioned whether reading `DataChecksumState->fast_checkpoint` without hol… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%2...> Introduce XID age based replication slot invalidation <https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based%...> The discussion concerns a patch to invalidate replication slots based on XID age. The key design decision is how to handle slots held by active walsenders. Masahiko Sawada and Bha… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based%...> SQL/JSON json_table plan clause <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20plan...> The discussion focuses on a multi-patch series fixing bugs in the SQL/JSON `JSON_TABLE` plan clause implementation. Thom Brown tested patches 0001–0003: 0001 fixes `ERROR ON EMPTY… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20plan...> Batching in executor <https://pgnexus.ai/hacker-discussions?subject=Batching%20in%20executor> Denis Smirnov posted a WIP patch as a heap-only experiment related to the broader "Batching in executor" discussion. The patch modifies heap_getnextslot() to reuse visible tuple o… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Batching%20in%20executor> support create index on virtual generated column. <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on%...> A patch to support creating indexes on virtual generated columns is under development (now at V6). ZizhuanLiu reports that CFBot test results reveal a truncation issue in the gene… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on%...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-12-postgresql-daily-news-205.m...> Industry News [image: Apple Sues OpenAI Over Alleged Trade Secret Theft] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Apple Sues OpenAI Over Alleged Trade Secret Theft <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Apple has filed a lawsuit against OpenAI, alleging the theft of trade secrets. According to Apple, the misconduct was directed by OpenAI's senior leadership, including a longtime… [image: Meta Removes Controversial AI Feature on Instagram After User Backlash] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Meta Removes Controversial AI Feature on Instagram After User Backlash <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Meta has pulled a controversial AI feature from Instagram following significant user backlash. The company stated in a blog post that the feature was intended as a useful creative… Social Media Updates linkedin CYBERTEC CEO Hans-Juergen Schoenig on why self-healing, always-on infrastructure matters when the data actually matters, and why open source gives you options a vendor never will. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> CYBERTEC CEO Hans-Juergen Schoenig discusses the importance of self-healing, always-on infrastructure for organizations where data reliability is critical. He argues that when dat… linkedin Pavlo Golub of Cybertec shares his talk "pgcov: Bringing Real Test Coverage to PostgreSQL Code" at POSETTE: An Event for Postgres 2026. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> At POSETTE 2026, Pavlo Golub from Cybertec presented pgcov, a tool aimed at filling a gap in the PostgreSQL ecosystem. While developers rely heavily on PostgreSQL functions, proce… linkedin Thanks to everyone who stopped by and interacted with us at GITEX AI EUROPE 2026. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> The author expresses gratitude to all attendees who visited and engaged with them at GITEX AI EUROPE 2026, reflecting briefly on the event as an incredible experience. No further… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more