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.

TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning

Jun 09, 2026 | Brandon Purcell

TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning

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
Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents

Jun 08, 2026 | Kavita Vellala

Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents

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

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

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
Adding REPACK [concurrently]

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
Proposal: Conflict log history table for Logical Replication

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
index prefetching

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
eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)

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

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.

Google will pay SpaceX $920M per month for compute

techcrunch.com

Google will pay SpaceX $920M per month for compute

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…

OpenAI files confidentially for IPO following Anthropic

techcrunch.com

OpenAI files confidentially for IPO following Anthropic

OpenAI has filed confidentially for an initial public offering, approximately one week after its primary competitor Anthropic also submitted IPO paperwork. This development intens…

Apple launches major Siri AI overhaul as voice assistant becomes AI companion

techcrunch.com

Apple launches major Siri AI overhaul as voice assistant becomes AI companion

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…

OpenAI unveils Lockdown Mode to protect sensitive data from prompt injection attacks

techcrunch.com

OpenAI unveils Lockdown Mode to protect sensitive data from prompt injection attacks

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 to learn more