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.

Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method

May 25, 2026 | Slava Sarzhan

Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method

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
The Postgres Developer's Guide to Vector Index Tradeoffs

May 26, 2026 | Hien Phan

The Postgres Developer's Guide to Vector Index Tradeoffs

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
Postgres Pro Shardman 18 — Review

May 25, 2026 | postgrespro.com

Postgres Pro Shardman 18 — Review

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

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

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]

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

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

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.

OpenRouter more than doubles valuation to $1.3B in a year

techcrunch.com

OpenRouter more than doubles valuation to $1.3B in a year

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…

Dutch government blocks US company from acquisition, citing 'risk to public interest'

techcrunch.com

Dutch government blocks US company from acquisition, citing 'risk to public interest'

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…

Amazon fulfillment competitor Stord raises $250M at $3B valuation

techcrunch.com

Amazon fulfillment competitor Stord raises $250M at $3B valuation

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…

Amazon fulfillment competitor Stord raises $250M at $3B valuation

techcrunch.com

Amazon fulfillment competitor Stord raises $250M at $3B valuation

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