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