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.

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

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

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]

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

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.

Google Search as you know it is over

techcrunch.com

Google Search as you know it is over

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…

OpenAI co-founder Andrej Karpathy joins Anthropic's pre-training team

techcrunch.com

OpenAI co-founder Andrej Karpathy joins Anthropic's pre-training team

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…

Hackers have compromised dozens of popular open source packages

techcrunch.com

Hackers have compromised dozens of popular open source packages

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…

Hackers have compromised dozens of popular open source packages

techcrunch.com

Hackers have compromised dozens of popular open source packages

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