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. [image: Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Jun 30, 2026 | Vigneshwaran C Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> [image: Too many tables are bad for you] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> Jun 30, 2026 | Laurenz Albe Too many tables are bad for you <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> [image: Community Docker Images: keeping the operator open without a vendor registry lock-in] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpos...> Jun 30, 2026 | Slava Sarzhan Community Docker Images: keeping the operator open without a vendor registry lock-in <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpos...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpos...> 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 <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...> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> 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 <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> 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 <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> 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 <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> 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 <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> 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. [image: Anthropic launches Claude Sonnet 5 as a cheaper alternative for AI agents] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Anthropic launches Claude Sonnet 5 as a cheaper alternative for AI agents <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> 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… [image: Amazon launches $1B Field Deployment Engineering org to embed AI agents at enterprises] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Amazon launches $1B Field Deployment Engineering org to embed AI agents at enterprises <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> 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 <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> 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… [image: Nvidia rival Etched reaches $5B valuation with $1B in contracted AI chip sales] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Nvidia rival Etched reaches $5B valuation with $1B in contracted AI chip sales <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> 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 <https://pgnexus.ai> to learn more