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%2Fmig...> 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%2Fmig...> 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%2Fmig...> [image: The Postgres Developer's Guide to Vector Index Tradeoffs] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ft...> 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%2Ft...> 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%2Ft...> [image: Postgres Pro Shardman 18 — Review] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fcom...> May 25, 2026 | postgrespro.com Postgres Pro Shardman 18 — Review <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fcom...> 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%2Fcom...> 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%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...> 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%5Bconcurren...> 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...> 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%2F...> 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%2F...> 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%2F...> 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%2F...> 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%2F...> techcrunch.com Amazon fulfillment competitor Stord raises $250M at $3B valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2F...> 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%2F...> techcrunch.com Amazon fulfillment competitor Stord raises $250M at $3B valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2F...> 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