Pgtechweeklyen

By thread

pgtechweeklyen@ivorysql.org

1 participants
18 messages

PGNexus Weekly News 2026-07-08

by pgnexus

PGNexus Weekly News This Week in PostgreSQL This week covers PostgreSQL 18 logical replication enhancements on Amazon RDS, a critical JDBC security fix patching a channel-binding downgrade vulnerability, CloudNativePG 1.30.0 with new CVE fixes and a DatabaseRole CRD, and multi-region disaster recovery using CloudNativePG distributed topology on Kubernetes. Together these updates highlight replication improvements, security hardening, operator maturity, and cloud-native resilience for PostgreSQL practitioners. [image: Logical replication improvements in Amazon RDS for PostgreSQL 18] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Jul 07, 2026 | Ramdas Gutlapalli Logical replication improvements in Amazon RDS for PostgreSQL 18 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> PostgreSQL 18 introduces four targeted improvements to logical replication. First, STORED generated columns can now be included in the replication stream via a new `publish_genera… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Going Multi-Region: How to Set Up CloudNativePG(CNPG) Distributed Topology] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Jul 07, 2026 | Wellingtone Luvonga Going Multi-Region: How to Set Up CloudNativePG(CNPG) Distributed Topology <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> This article demonstrates how to configure CloudNativePG (CNPG) distributed topology across multiple Kubernetes clusters for PostgreSQL disaster recovery. The setup uses MinIO as… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Top 5 Hacker Discussions Index prefetching (V29) adds microoptimizations reducing amgetbatch calls and per-tuple stat overhead, plus EXPLAIN (ANALYZE, IO) instrumentation. Row pattern recognition review surfaces a wrong-result bug in context-absorption and disputes over walker refactoring. REPACK CONCURRENTLY deadlock fix is deferred to pg20. Logical replication sees active debate on conflict-log safety and a decision to leave UNLOGGED publication handling unchanged pending unresolved restore semantics. Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> The discussion concerns a proposed conflict log history table for logical replication. Robert Haas raised two concerns about the v63-0001 patch design: (1) saving aside an error m… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> A potential deadlock issue in the REPACK [concurrently] feature risks losing large amounts of work. Mihail Nikalayeu proposed a patch to address it. Alvaro Herrera reviewed the pa… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Henson Choi reviews several aspects of the row pattern recognition patch. First, he acknowledges Jian's offset resolution consolidation as a useful direction—it enables EXPLAIN to… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan posted V29 of the index prefetching patch, noting V28 no longer applies cleanly. Key changes include two microoptimizations: index AMs can now set knownEndBackward… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> This Week's Industry Movements Microsoft launched a $2.5B AI deployment company while separately shifting toward in-house models to cut costs. Anthropic is negotiating a custom chip deal with Samsung, joining an industry push for proprietary silicon. Alibaba banned Claude Code internally, citing security risks around Western AI tools. Meta's Zuckerberg admitted AI agent progress has lagged internal expectations, offering a rare candid signal amid the broader AI investment frenzy. [image: Microsoft launches its own AI deployment company with $2.5 billion commitment] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Microsoft launches its own AI deployment company with $2.5 billion commitment <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Microsoft has launched a new AI deployment company backed by a $2.5 billion commitment, joining Amazon, OpenAI, and Anthropic in establishing dedicated AI deployment operations. T… [image: Anthropic Discusses Custom AI Chip Development with Samsung] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Anthropic Discusses Custom AI Chip Development with Samsung <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic is in discussions with Samsung to develop a new custom AI chip, according to a TechCrunch report. The news follows OpenAI's recent announcement of its own custom AI chip… [image: Alibaba Reportedly Bans Employees from Using Claude Code] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Alibaba Reportedly Bans Employees from Using Claude Code <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Alibaba has reportedly classified Claude Code, Anthropic's AI-powered coding assistant, as high-risk software and banned its employees from using it. The move signals growing tens… [image: Mark Zuckerberg Tells Staff Meta's AI Agents Progressing Slower Than Expected] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Mark Zuckerberg Tells Staff Meta's AI Agents Progressing Slower Than Expected <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Meta CEO Mark Zuckerberg reportedly told employees at an internal meeting that the company's AI agent development has not advanced as quickly as he had hoped. The candid admission… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

July 8, 2026

PGNexus Weekly News 2026-07-01

by pgnexus

PGNexus Weekly News This Week in PostgreSQL This week covers PostgreSQL 19 upgrade workflow gaps with sequence synchronization, a new open-source data tiering extension from pgEdge, critical memory and performance risks from oversized schemas, and community container images freeing operators from vendor registries. Together these posts address reliability, cost, performance, and operational independence—core concerns for PostgreSQL teams managing production systems. [image: Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Jun 30, 2026 | Vigneshwaran C Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> PostgreSQL 19 introduces improvements to upgrade workflows using pg_upgrade and pg_createsubscriber, enabling near-zero-downtime upgrades by converting physical replicas into logi… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: Too many tables are bad for you] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Jun 30, 2026 | Laurenz Albe Too many tables are bad for you <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> A PostgreSQL database containing tens of thousands of tables can cause two serious problems: excessive memory usage and slow metadata queries. Each long-lived connection accumulat… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: Community Docker Images: keeping the operator open without a vendor registry lock-in] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpo…> Jun 30, 2026 | Slava Sarzhan Community Docker Images: keeping the operator open without a vendor registry lock-in <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpo…> Percona Operator for PostgreSQL 3.0.0 introduces Community PostgreSQL Images, allowing users to run the operator against container images built from official PostgreSQL packages s… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpo…> Top 5 Hacker Discussions Active patch development spans logical replication conflict logging, index prefetching, row pattern recognition, and REPACK CONCURRENTLY. The conflict log history table patch consolidated two patches and addressed ACL, error code, and GUC scope debates. Index prefetching v28 introduces SP-GiST amgetbatch support, revised heap-switch heuristics, and INDEX_PAGES_LIMIT. RPR v50 focuses on CI breakage from upstream NULLS handling changes. A proposed UNLOGGED table cleanup in publications was abandoned after review. Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> Peter Smith reviewed v59-0001/0002 of the conflict log history table (CLT) patch for logical replication, raising several issues: inconsistent JSON/json casing in comments, column… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> Antonin Houska submitted a small patch to the ongoing "Adding REPACK [concurrently]" thread, removing an outdated comment that was only valid in earlier versions of the patch. The… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Henson Choi is preparing for the next review round of the Row Pattern Recognition (RPR) patch series (v50). Two issues are flagged: first, cfbot is failing on v49 because a recent… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan posted v28 of the index prefetching patch set, with several notable changes. The "start read stream" heuristic now triggers on the fourth heap block switch rather… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> This Week's Industry Movements Anthropic's Claude Sonnet 5 launches as a cost-efficient agent model, while Amazon commits $1 billion to embed AI agents directly at enterprises. The Trump administration authorizes Mythos 5 for over 100 U.S. companies and agencies. Meanwhile, Nvidia rival Etched hits a $5 billion valuation with $1 billion in contracted chip sales, signaling serious enterprise appetite for AI hardware alternatives. Together, these moves mark a week of rapid AI commercialization across models, infrastructure, and deployment. [image: Anthropic launches Claude Sonnet 5 as a cheaper alternative for AI agents] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Anthropic launches Claude Sonnet 5 as a cheaper alternative for AI agents <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Anthropic has launched Claude Sonnet 5, a new model designed to offer stronger agentic capabilities at a lower price point. The release positions Claude Sonnet 5 as a more cost-ef… [image: Amazon launches $1B Field Deployment Engineering org to embed AI agents at enterprises] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Amazon launches $1B Field Deployment Engineering org to embed AI agents at enterprises <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Amazon has launched a new $1 billion Field Deployment Engineering (FDE) organization, following similar moves by OpenAI and Anthropic. Engineers on the new team will embed directl… techcrunch.com Trump Admin releases Anthropic Mythos to be used by more than 100 US companies, agencies <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> The Trump administration has authorized more than 100 U.S. companies and government agencies to use Anthropic's Mythos 5 AI model, including access for their non-American employee… [image: Nvidia rival Etched reaches $5B valuation with $1B in contracted AI chip sales] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Nvidia rival Etched reaches $5B valuation with $1B in contracted AI chip sales <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> AI chip startup Etched, a competitor to Nvidia, has announced it has reached a $5 billion valuation and already secured $1 billion in contracted sales for inference systems powere… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

July 1, 2026

PGNexus Weekly News 2026-06-24

by pgnexus

PGNexus Weekly News This Week in PostgreSQL This week brings critical security fixes in pgAdmin 4 v9.16 addressing seven CVEs, a new postgres-lsp language server offering rich editor integration for SQL and PL/pgSQL, a fresh community backup tool pg_hardstorage targeting modern deployment models, and a practical deep-dive into partition key write bottlenecks with diagnostic queries. Together these updates cover tooling, security, performance, and reliability across the PostgreSQL ecosystem. [image: Introducing pg_hardstorage: A New Community-Driven Approach to PostgreSQL Backup and Recovery] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Jun 23, 2026 | Hans-Jürgen Schönig Introducing pg_hardstorage: A New Community-Driven Approach to PostgreSQL Backup and Recovery <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> CYBERTEC has released pg_hardstorage, a new open-source PostgreSQL backup and recovery tool licensed under Apache 2.0. The project does not aim to replace existing tools like pgBa… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: Why Your PostgreSQL Partition Key Is Creating a Write Bottleneck] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Jun 19, 2026 | NanoHertz Communications Why Your PostgreSQL Partition Key Is Creating a Write Bottleneck <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> A skewed PostgreSQL partition key can route the majority of writes to a single partition, creating a write hot spot while others sit idle. This causes cascading problems: excessiv… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Top 5 Hacker Discussions Index prefetching (v28) refines stream heuristics, adds SP-GiST amgetbatch support, and introduces INDEX_PAGES_LIMIT. Logical replication work spans a conflict log history table under active review and a publication EXCEPT-clause edge case resolved without code change. Row Pattern Recognition reports 98.4% line coverage and clean Valgrind results. REPACK CONCURRENTLY received a minor stale-comment cleanup. Most threads remain open with unresolved implementation questions around memory layout, API correctness, and permission checks. Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> Antonin Houska submitted a small patch to the ongoing "Adding REPACK [concurrently]" thread, removing an outdated comment that was only valid in earlier versions of the patch. The… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> The discussion concerns a proposed conflict log history table (CLT) for logical replication in PostgreSQL. Dilip Kumar merged patches from Amit Kapila and Nisha Moond and confirme… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan posted v28 of the index prefetching patch set, with several notable changes. The "start read stream" heuristic now triggers on the fourth heap block switch rather… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Henson Choi posted two follow-up reports on the Row Pattern Recognition (RPR) patch. The first covers an updated code coverage analysis: modified-line coverage improved from 96.5%… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> This Week's Industry Movements Amazon is opening its AI chips to third-party data centers, targeting a $50 billion market and challenging Nvidia's dominance. Groq confirmed a $650 million raise to stay independent after a notable Nvidia deal fell through. SpaceX signed a $150 million per month compute contract with Reflection AI through 2029. Anthropic launched Claude Tag for Slack, embedding persistent AI context capture into enterprise workflows. [image: Amazon Seeks to Sell Its AI Chips to External Data Centers, Challenging Nvidia] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Amazon Seeks to Sell Its AI Chips to External Data Centers, Challenging Nvidia <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> AWS is in talks to sell its proprietary AI chips to third-party data centers, a move that positions Amazon more directly against Nvidia in the AI hardware market. CEO Andy Jassy h… [image: Groq Confirms $650M Funding Round After Nvidia's Not-Acqui-Hire Deal] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Groq Confirms $650M Funding Round After Nvidia's Not-Acqui-Hire Deal <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> AI chipmaker Groq has confirmed a $650 million funding raise following a high-profile not-acqui-hire deal with Nvidia valued at $20 billion. Rather than being absorbed, Groq is le… [image: SpaceX Signs $150M/Month Compute Deal with Open-Source AI Lab Reflection AI] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com SpaceX Signs $150M/Month Compute Deal with Open-Source AI Lab Reflection AI <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> SpaceX has signed a major compute agreement with Reflection AI, an open-source AI lab. Under the deal, Reflection AI will pay $150 million per month starting July 1, 2026, through… [image: Anthropic's Claude Tag Brings Always-On AI to Slack for Enterprise Context Capture] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Anthropic's Claude Tag Brings Always-On AI to Slack for Enterprise Context Capture <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Anthropic has launched Claude Tag, a new feature that integrates its AI model directly into Slack as a persistent, always-on teammate. Beyond boosting individual productivity, Cla… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

June 24, 2026

PGNexus Weekly News 2026-06-17

by pgnexus

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%2F…> 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%2F…> 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%2F…> 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%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> 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%5Bconcurre…> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> 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%…> 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%2…> 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%2…> 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%2…> techcrunch.com US Government Bans Anthropic's Most Powerful Cybersecurity Models <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> 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%2…> techcrunch.com Anthropic taps TCS to scale its enterprise AI deployments <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> 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%2…> 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%2…> 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%2…> techcrunch.com ChatGPT Market Share Drops Below 50% for First Time <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> 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

June 17, 2026

PGNexus Weekly News 2026-06-10

by pgnexus

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%2F…> 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%2F…> 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%2F…> [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%2Fda…> 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%2Fda…> 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%2Fda…> 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%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> 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%5Bconcurre…> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> 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%…> 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%2…> 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%2…> 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%2…> techcrunch.com Google will pay SpaceX $920M per month for compute <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> 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%2…> techcrunch.com OpenAI files confidentially for IPO following Anthropic <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> 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%2…> 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%2…> 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%2…> 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%2…> 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

June 10, 2026

PGNexus Weekly News 2026-06-03

by pgnexus

PGNexus Weekly News This Week in PostgreSQL This week's PostgreSQL highlights include Percona Operator 3.0.0 completing its hard fork from Crunchy Data for independent Kubernetes deployments, Autobase 2.8.0 splitting into Community and Enterprise editions, Neon expanding paid plan data transfer fivefold to 500 GB monthly, and deep insights from contributors on improving logical replication for upgrades and multi-region pipelines. Tooling, reliability, and ecosystem evolution remain front and center. [image: Percona Operator for PostgreSQL 3.0.0: Hard Fork, OLM Scoping, Major Upgrades] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpe…> May 28, 2026 | Slava Sarzhan Percona Operator for PostgreSQL 3.0.0: Hard Fork, OLM Scoping, Major Upgrades <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpe…> Percona Operator for PostgreSQL 3.0.0 completes its hard fork from Crunchy Data's operator, becoming fully independent. Key changes include renaming Custom Resource Definitions to… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpe…> [image: We're including 5x more data transfer in all paid plans] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fmore-data…> Jun 01, 2026 | Brad Van Vugt We're including 5x more data transfer in all paid plans <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fmore-data…> Neon announces a significant increase in data transfer allowances for paid plans, effective June 1, 2026. All paid subscribers now receive 500 GB of monthly data transfer, up from… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fmore-data…> [image: How to hack Logical Replication in PostgreSQL: Insights from contributors] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> May 28, 2026 | Zhijie Hou How to hack Logical Replication in PostgreSQL: Insights from contributors <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Logical replication in PostgreSQL has evolved significantly since its introduction and is now widely adopted for cross-version upgrades, multi-region deployments, and real-time an… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Top 5 Hacker Discussions Active PostgreSQL development spans replication, storage, and access method improvements. REPACK CONCURRENTLY saw its first patch portion committed after catalog_xmin debate. Logical replication conflict logging continues iterating on destination option design, with enum versus string-parameter disagreement unresolved. Index prefetching targeting PostgreSQL 20 returned at v25 with slot-based interface prioritized. WAL reduction via xl_heap_visible elimination received test stability commits. A publication EXCEPT-clause cleanup patch was abandoned after reviewers found no justification for behavioral change. Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> Amit Kapila and Zhijie Hou discussed concerns about catalog_xmin handling in the REPACK CONCURRENTLY feature. Kapila questioned whether the patch should advance catalog_xmin to pr… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> The discussion focuses on implementing a conflict log history table feature for PostgreSQL logical replication. Dilip Kumar released patch v44 incorporating feedback from multiple… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan has resumed work on index prefetching for PostgreSQL 20 after taking time away from the project. He posted v25 of the patch set, which contains no substantive chan… 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%2…> 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%2…> This Week's Industry Movements Anthropic filed for an IPO after raising $65 billion at a near-trillion-dollar valuation, while also releasing Opus 4.8 with multi-agent Dynamic Workflows. Google launched Gemini Spark, a 24/7 AI automation assistant. Meanwhile, hackers exploited Meta's AI support chatbot to hijack Instagram accounts, exposing serious security risks when AI systems with elevated permissions lack adequate safeguards. [image: Anthropic files to go public] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Anthropic files to go public <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Anthropic, the AI company behind the Claude chatbot, announced Monday that it has confidentially filed for an initial public offering. The move marks a significant step for the AI… [image: Anthropic raises $65 billion, nears $1T valuation ahead of IPO] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Anthropic raises $65 billion, nears $1T valuation ahead of IPO <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Anthropic has completed a $65 billion Series H funding round, reaching a post-money valuation of $965 billion. This massive fundraise is believed to be the company's final private… [image: Google's Gemini Spark AI assistant launches with 24/7 automation features] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Google's Gemini Spark AI assistant launches with 24/7 automation features <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Google has launched Gemini Spark, a new 24/7 AI assistant designed to automate everyday tasks such as inbox summaries and local event planning. Early testing shows the tool is gen… [image: Hackers hijacked Instagram accounts by tricking Meta AI support chatbot into granting access] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Hackers hijacked Instagram accounts by tricking Meta AI support chatbot into granting access <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Several Instagram users reported over the weekend that their accounts had been compromised through an exploitation of Meta's AI-powered support chatbot. Hackers manipulated the au… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

June 3, 2026

PGNexus Weekly News 2026-05-27

by pgnexus

PGNexus Weekly News This Week in PostgreSQL This week covers PostgreSQL's expanding AI ecosystem, with new extensions enabling transformer inference, Datalog queries, and approximate regex indexing directly inside Postgres. A detailed migration guide helps operators move between Kubernetes-based operators with minimal downtime, while a vector index tradeoff guide addresses practical AI workload decisions. Shardman 18 brings enterprise-grade horizontal sharding to PostgreSQL 18, rounding out a technically rich week for DBAs and developers alike. [image: Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> May 25, 2026 | Slava Sarzhan Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> This blog post provides a detailed technical guide for migrating from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator using the standby cluster method. The migrati… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> [image: The Postgres Developer's Guide to Vector Index Tradeoffs] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> May 26, 2026 | Hien Phan The Postgres Developer's Guide to Vector Index Tradeoffs <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> This comprehensive guide examines vector index selection in PostgreSQL, focusing on four key constraints: memory, recall requirements, write frequency, and filter selectivity. The… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> [image: Postgres Pro Shardman 18 — Review] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> May 25, 2026 | postgrespro.com Postgres Pro Shardman 18 — Review <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> Postgres Pro has released Shardman 18, a sharding extension for PostgreSQL that enables horizontal scaling across multiple nodes. This version introduces improved query planning a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> Top 5 Hacker Discussions Multiple patches and commits are in active progress: WAL reduction efforts include fixes for REPACK CONCURRENTLY accumulation and elimination of xl_heap_visible records, with test stability commits landed. Index prefetching API design debates continue around TupleTableSlot usage versus dedicated interfaces, with code consolidation concerns raised. pg_plan_advice received a corrected fix from Haas. A proposed cleanup for UNLOGGED table entries in publication EXCEPT lists was abandoned after review deemed current behavior acceptable. Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> A patch for fixing WAL accumulation during REPACK CONCURRENTLY has been submitted by Zhijie Hou after attending a pgconf.dev talk that clarified this behavior is unintended. The i… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%2…> 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%2…> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan responds to Andres Freund's feedback on index prefetching implementation details. The discussion focuses on API design for index-only scans, particularly whether t… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> pg_plan_advice <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice> Robert Haas responded to Tender Wang's proposed fix for pg_plan_advice, indicating that the suggested solution was not quite correct. The fix had issues with filtering unique reli… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice> This Week's Industry Movements OpenRouter raised $113M at a $1.3B valuation, signaling strong demand for multi-model AI infrastructure as usage surged fivefold in six months. Meanwhile, the Dutch government blocked a US firm from acquiring a cloud provider hosting national digital ID services, highlighting Europe's push for data sovereignty over critical infrastructure. Stord secured $250M to challenge Amazon in e-commerce fulfillment while letting brands retain customer relationships. [image: OpenRouter more than doubles valuation to $1.3B in a year] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com OpenRouter more than doubles valuation to $1.3B in a year <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> OpenRouter has raised a $113 million Series B funding round led by CapitalG, more than doubling its valuation to $1.3 billion within a year. The company provides a platform that a… [image: Dutch government blocks US company from acquisition, citing 'risk to public interest'] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Dutch government blocks US company from acquisition, citing 'risk to public interest' <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> The Dutch government has blocked a US company from acquiring a cloud services provider that hosts the Netherlands' digital ID service, citing risks to public interest. This decisi… [image: Amazon fulfillment competitor Stord raises $250M at $3B valuation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Amazon fulfillment competitor Stord raises $250M at $3B valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Stord has raised $250 million in funding at a $3 billion valuation, positioning itself as a competitor to Amazon's fulfillment services. The company operates a network of physical… [image: Amazon fulfillment competitor Stord raises $250M at $3B valuation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Amazon fulfillment competitor Stord raises $250M at $3B valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Stord has raised $250 million in funding at a $3 billion valuation, positioning itself as a competitor to Amazon's fulfillment services. The company operates a network of physical… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

May 27, 2026

PGNexus Weekly News 2026-05-26

by pgnexus

PGNexus Weekly News This Week in PostgreSQL This week's PostgreSQL highlights include Barman 3.18.0 with experimental block-level incremental cloud backups, pg_tre 1.1.1 introducing approximate regex indexing for PostgreSQL 18+, Postgres Pro Shardman 18 delivering enterprise horizontal scaling, and a practical guide for migrating from Crunchy Data to Percona PostgreSQL Operator with minimal downtime. Together these releases advance backup efficiency, search capabilities, distributed scaling, and Kubernetes operator flexibility. [image: Postgres Pro Shardman 18 — Review] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> May 25, 2026 | postgrespro.com Postgres Pro Shardman 18 — Review <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> Postgres Pro has released Shardman 18, a sharding extension for PostgreSQL that enables horizontal scaling across multiple nodes. This version introduces improved query planning a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> [image: Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> May 25, 2026 | Slava Sarzhan Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> This blog post provides a detailed technical guide for migrating from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator using the standby cluster method. The migrati… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> Top 5 Hacker Discussions Several active development threads addressed pre-beta stabilization concerns. A db-specific snapshot feature for concurrent REPACK was agreed to revert from PostgreSQL 19 and retry in version 20. Index prefetching API design debates continue around slot interfaces and code duplication across table access methods. WAL reduction work targeting xl_heap_visible elimination saw multiple test reliability commits. A pg_plan_advice fix was pushed with a corrected relid filtering implementation. A proposed publication EXCEPT-clause cleanup for UNLOGGED tables was ultimately abandoned. Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> The discussion focuses on a patch for database-specific snapshots to enable concurrent REPACK operations. Amit Kapila raises concerns about the architectural implications, noting… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%2…> 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%2…> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan responds to Andres Freund's feedback on index prefetching implementation details. The discussion focuses on API design for index-only scans, particularly whether t… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> pg_plan_advice <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice> Robert Haas responded to Tender Wang's proposed fix for pg_plan_advice, indicating that the suggested solution was not quite correct. The fix had issues with filtering unique reli… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice> This Week's Industry Movements This week in AI and tech: Google is overhauling Search into a conversational, agent-driven experience that may drastically cut web traffic to publishers. Andrej Karpathy, OpenAI co-founder, joins Anthropic's pre-training team in a major talent win for Claude's development. Meanwhile, a supply-chain attack campaign called Mini Shai-Hulud has compromised dozens of popular open source packages, threatening developers and downstream applications worldwide. [image: Google Search as you know it is over] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Google Search as you know it is over <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Google is fundamentally transforming its Search product from a traditional list of links into an AI-powered experience centered on conversational answers, autonomous agents, and i… [image: OpenAI co-founder Andrej Karpathy joins Anthropic's pre-training team] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com OpenAI co-founder Andrej Karpathy joins Anthropic's pre-training team <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Andrej Karpathy, a co-founder of OpenAI and prominent AI researcher, has joined Anthropic to work on its pre-training team. Pre-training is the phase responsible for large-scale t… [image: Hackers have compromised dozens of popular open source packages] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Hackers have compromised dozens of popular open source packages <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Dozens of popular open source software packages have been compromised in an ongoing supply-chain attack campaign known as Mini Shai-Hulud. The attackers have successfully infiltra… [image: Hackers have compromised dozens of popular open source packages] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Hackers have compromised dozens of popular open source packages <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Dozens of popular open source software packages have been compromised in an ongoing supply-chain attack campaign known as Mini Shai-Hulud. The attackers have successfully infiltra… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

May 26, 2026