PGNexus Weekly News 2026-06-17
PGNexus Weekly News This Week in PostgreSQL This week's PostgreSQL highlights include a new extension enforcing partition pruning at the database level, a workload monitoring tool update with per-module retention, key management best practices for TDE deployments, and a timely look at workloads where PostgreSQL's MVCC model creates architectural challenges. Together these cover security, performance, tooling, and honest architectural guidance for practitioners. [image: On the Role of Key Management in PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> Jun 16, 2026 | Petar Lejic On the Role of Key Management in PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> Transparent Data Encryption (TDE) in PostgreSQL environments solves data-at-rest security but creates operational challenges around key access. Without proper key management, keys… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> [image: When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fw...> Jun 12, 2026 | NanoHertz Communications When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fw...> PostgreSQL excels at 90% of workloads but struggles with a specific 10%: high-frequency append-only ingestion with sustained write rates and analytical query patterns. When worklo… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fw...> Top 5 Hacker Discussions Index prefetching v27 simplifies batch buffer management and adds Valgrind test infrastructure, with CI failures and cost model improvements still pending. WAL reduction via xl_heap_visible elimination saw multiple test stability commits addressing autovacuum interference. Logical replication conflict log table development debates view permissions in pg_conflict and has open bugs around two-phase transaction metadata. REPACK's concurrent deadlock issue remains unresolved. A publication EXCEPT clause cleanup patch was abandoned after review raised conversion reversibility concerns. 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 the conflict log table (CLT) feature for logical replication within the `pg_conflict` schema. A key debate concerns whether view creation should be allow… 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 v27 of the index prefetching patch, addressing outstanding issues from the paused work after Postgres 19's final commit fest. The major change simplifies… 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 This week's AI landscape saw major regulatory tension as the Trump administration forced Anthropic to pull its cybersecurity models Fable and Mythos, while Anthropic also partnered with TCS to scale enterprise Claude deployments. Salesforce acquired AI customer service platform Fin for $3.6 billion to strengthen Agentforce. ChatGPT's market share fell below 50% for the first time, with Gemini and Claude gaining ground. Oracle confirmed a critical vulnerability actively exploited to breach over 100 organizations. [image: US Government Bans Anthropic's Most Powerful Cybersecurity Models] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com US Government Bans Anthropic's Most Powerful Cybersecurity Models <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> The Trump administration forced Anthropic to pull its latest cybersecurity models, Fable and Mythos, through export-control restrictions. Analysts suggest the decision may be reac… [image: Anthropic taps TCS to scale its enterprise AI deployments] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Anthropic taps TCS to scale its enterprise AI deployments <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> Anthropic has announced a strategic partnership with Tata Consultancy Services (TCS) to accelerate the deployment of its AI models across enterprise customers. Under this collabor… [image: Salesforce acquires AI customer service platform Fin for $3.6B] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Salesforce acquires AI customer service platform Fin for $3.6B <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> Salesforce announced the acquisition of Fin, an AI-powered customer service platform, for $3.6 billion. The company plans to integrate Fin's team and technology into Agentforce, i… [image: ChatGPT Market Share Drops Below 50% for First Time] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com ChatGPT Market Share Drops Below 50% for First Time <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> ChatGPT's share of the global AI assistant market has fallen below 50% for the first time, marking a notable shift in the competitive landscape. Despite the decline, ChatGPT remai… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more
participants (1)
-
pgnexus