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.

Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization

Jun 30, 2026 | Vigneshwaran C

Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization

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
Too many tables are bad for you

Jun 30, 2026 | Laurenz Albe

Too many tables are bad for you

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
Community Docker Images: keeping the operator open without a vendor registry lock-in

Jun 30, 2026 | Slava Sarzhan

Community Docker Images: keeping the operator open without a vendor registry lock-in

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

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

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
Proposal: Conflict log history table for Logical Replication

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
Adding REPACK [concurrently]

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
Row pattern recognition

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

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

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.

Anthropic launches Claude Sonnet 5 as a cheaper alternative for AI agents

techcrunch.com

Anthropic launches Claude Sonnet 5 as a cheaper alternative for AI agents

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…

Amazon launches $1B Field Deployment Engineering org to embed AI agents at enterprises

techcrunch.com

Amazon launches $1B Field Deployment Engineering org to embed AI agents at enterprises

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

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…

Nvidia rival Etched reaches $5B valuation with $1B in contracted AI chip sales

techcrunch.com

Nvidia rival Etched reaches $5B valuation with $1B in contracted AI chip sales

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