PGNexus Weekly News This Week in PostgreSQL This week's PostgreSQL highlights include the PostgreSQL 19 Beta 1 release with major performance, security, and developer feature additions. TimescaleDB 2.27 delivers up to 160x faster UPDATE/DELETE on compressed data. PostgreSQL Anonymizer 3.1 adds Local Differential Privacy with a critical security fix requiring immediate upgrade. AWS introduces an AI-powered Oracle PL/SQL to PostgreSQL migration tool achieving 92% conversion confidence. [image: TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ft...> Jun 09, 2026 | Brandon Purcell TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ft...> TimescaleDB 2.27 introduces significant performance improvements focused on eliminating unnecessary work in analytical operations. The release extends bloom filter technology to a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ft...> [image: Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> Jun 08, 2026 | Kavita Vellala Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> AWS has released a solution to automate Oracle PL/SQL to PostgreSQL migration using Amazon Bedrock with Anthropic's Claude Sonnet 4.6, the Strands Agents framework, and AWS Knowle… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> Top 5 Hacker Discussions Index prefetching (v26) adds GiST batch scan support with 20x+ speedups alongside API changes and outstanding planner cost model gaps. WAL reduction work on xl_heap_visible received stabilizing test commits. Logical replication conflict log tables settled on allowing explicit locks while blocking direct mutations, with documentation planned. REPACK deadlock issues remain unresolved with stress testing ongoing. A proposed publication EXCEPT clause cleanup for UNLOGGED tables was abandoned after review. Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%20...> Vignesh C proposed a patch to handle UNLOGGED table conversions in PostgreSQL publications. The issue occurs when tables listed in publication EXCEPT clauses are converted to UNLO… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%20...> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> Mihail Nikalayeu reminds the PostgreSQL community about an unresolved deadlock issue in the REPACK functionality that can cause significant loss of work. He references a previous… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> The discussion focuses on conflict log tables (CLTs) for logical replication, specifically addressing user interaction policies. The main debate centers on whether to allow explic… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan released v26 of the index prefetching patch, introducing significant improvements after the pause following PostgreSQL 19's final commit fest. The standout additio… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%20...> The discussion centers on eliminating xl_heap_visible WAL records to reduce WAL volume and eventually set visibility map on access. Melanie Plageman committed several fixes to add… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%20...> This Week's Industry Movements Google's $920M/month compute deal with SpaceX signals unprecedented AI infrastructure demand. OpenAI files confidentially for IPO just weeks after Anthropic, marking a pivotal moment for AI public markets. Apple launches a major Siri AI overhaul, repositioning its voice assistant as a full AI companion. OpenAI also introduces Lockdown Mode to guard ChatGPT against prompt injection attacks, reflecting growing enterprise security concerns around AI systems. [image: Google will pay SpaceX $920M per month for compute] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Google will pay SpaceX $920M per month for compute <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> Google has struck a major deal with SpaceX, agreeing to pay $920 million per month for compute resources. According to a Google representative, the agreement stems from unexpected… [image: OpenAI files confidentially for IPO following Anthropic] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com OpenAI files confidentially for IPO following Anthropic <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> OpenAI has filed confidentially for an initial public offering, approximately one week after its primary competitor Anthropic also submitted IPO paperwork. This development intens… [image: Apple launches major Siri AI overhaul as voice assistant becomes AI companion] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Apple launches major Siri AI overhaul as voice assistant becomes AI companion <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> Apple has officially launched its long-awaited "Siri AI" overhaul, transforming the voice assistant from a basic voice-controlled tool into a comprehensive AI companion with signi… [image: OpenAI unveils Lockdown Mode to protect sensitive data from prompt injection attacks] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com OpenAI unveils Lockdown Mode to protect sensitive data from prompt injection attacks <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> OpenAI has introduced Lockdown Mode, a new security feature designed to protect sensitive data from prompt injection attacks in ChatGPT. Prompt injection attacks occur when malici… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more