PGNexus Daily News #220 2026-07-27
PGNexus Daily News PostgreSQL Technical Articles [image: WarehousePG on AWS: Control Your Analytics, Control Your Costs] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fwa...> enterprisedb.com WarehousePG on AWS: Control Your Analytics, Control Your Costs <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fwa...> WarehousePG is a massively parallel processing (MPP) analytical database derived from the Greenplum project, now maintained by EnterpriseDB under the Apache license after Greenplu… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fwa...> PostgreSQL Hackers Email Discussion Highlights explain plans for foreign servers <https://pgnexus.ai/hacker-discussions?subject=explain%20plans%20for%20foreig...> Dinesh Salve submitted patch v5 for the "explain plans for foreign servers" feature, incorporating feedback from Yilin. The changes include removing a blank line, initializing the… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=explain%20plans%20for%20foreig...> Fix missing FORMAT when deparsing JSON_ARRAY(query) <https://pgnexus.ai/hacker-discussions?subject=Fix%20missing%20FORMAT%20when%...> The thread addresses a bug fix for missing FORMAT when deparsing JSON_ARRAY(query). Richard Guo reviewed the patch, noting that handling format in expression_tree_mutator/walker a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20missing%20FORMAT%20when%...> [PATCH] Cover get_json_table_plan() with tests <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Cover%20get_json...> The patch adds test coverage for `get_json_table_plan()`. A third version was submitted after simplifying the patch by removing a now-unnecessary `IsA(plan, JsonTablePathScan)` br… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Cover%20get_json...> Fix race condition in pg_get_publication_tables with concurrent DROP TABLE <https://pgnexus.ai/hacker-discussions?subject=Fix%20race%20condition%20in%20...> Bharath Rupireddy submitted v10 patches fixing a race condition in pg_get_publication_tables when a concurrent DROP TABLE occurs. Masahiko Sawada reviewed and suggested moving ste… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20race%20condition%20in%20...> Track skipped tables during autovacuum and autoanalyze <https://pgnexus.ai/hacker-discussions?subject=Track%20skipped%20tables%20dur...> The discussion concerns a patch (v12) to track tables skipped during autovacuum and autoanalyze due to lock unavailability. Yugo Nagata incorporated earlier feedback from Kato-san… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Track%20skipped%20tables%20dur...> tablecmds: fix bug where index rebuild loses replica identity on partitions <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20whe...> Sami Imseih reviewed patch v9 for the bug fix where index rebuilds lose replica identity on partitions during ALTER TABLE ... ALTER COLUMN TYPE. He identified a remaining issue: g… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20whe...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-27-postgresql-daily-news-220.m...> Industry News techcrunch.com Microsoft launches its first AI cybersecurity model and agentic security platform <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Microsoft has bolstered its AI cybersecurity offerings with two major announcements: the launch of its first AI security model and a new agentic cybersecurity platform. The move s… techcrunch.com Ilya Sutskever's Safe Superintelligence partners with Nvidia to scale AI research <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Safe Superintelligence (SSI), the AI safety-focused startup founded by former OpenAI chief scientist Ilya Sutskever, has announced a long-term partnership with Nvidia after spendi… [image: Claude shared chats and Artifacts reportedly indexed by Google search] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Claude shared chats and Artifacts reportedly indexed by Google search <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Users of Anthropic's Claude AI assistant have been warned that shared chats and Artifacts may have been indexed by Google and made publicly discoverable. The issue stems from Clau… Social Media Updates [image: CYPEX is CYBERTEC's PostgreSQL Application Platform that enables you to build enterprise applications at low-code speed while leveraging PostgreSQL's security, scalability, and database guarantees.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin CYPEX is CYBERTEC's PostgreSQL Application Platform that enables you to build enterprise applications at low-code speed while leveraging PostgreSQL's security, scalability, and database guarantees. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> CYPEX is an application platform developed by CYBERTEC, built on top of PostgreSQL. It allows organizations to build enterprise applications quickly using a low-code approach, whi… linkedin For forty years, transactional and analytical databases were treated as separate systems, connected by pipelines that moved data between them. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> For four decades, transactional and analytical databases operated as separate systems linked by data pipelines. The rise of AI agents is driving a reconsideration of this architec… linkedin Virgin Atlantic is using data and AI to give its crew more context for a premium, personalized onboard experience. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Virgin Atlantic is integrating data and AI to enhance personalized service for passengers. VP of Data and AI Richard Masters describes how the airline consolidates booking, loyalt… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more
participants (1)
-
pgnexus