PGNexus Weekly News

This Week in PostgreSQL

This week brings critical security fixes in pgAdmin 4 v9.16 addressing seven CVEs, a new postgres-lsp language server offering rich editor integration for SQL and PL/pgSQL, a fresh community backup tool pg_hardstorage targeting modern deployment models, and a practical deep-dive into partition key write bottlenecks with diagnostic queries. Together these updates cover tooling, security, performance, and reliability across the PostgreSQL ecosystem.

Introducing pg_hardstorage: A New Community-Driven Approach to PostgreSQL Backup and Recovery

Jun 23, 2026 | Hans-Jürgen Schönig

Introducing pg_hardstorage: A New Community-Driven Approach to PostgreSQL Backup and Recovery

CYBERTEC has released pg_hardstorage, a new open-source PostgreSQL backup and recovery tool licensed under Apache 2.0. The project does not aim to replace existing tools like pgBa…

Read the Blog
Why Your PostgreSQL Partition Key Is Creating a Write Bottleneck

Jun 19, 2026 | NanoHertz Communications

Why Your PostgreSQL Partition Key Is Creating a Write Bottleneck

A skewed PostgreSQL partition key can route the majority of writes to a single partition, creating a write hot spot while others sit idle. This causes cascading problems: excessiv…

Read the Blog

Top 5 Hacker Discussions

Index prefetching (v28) refines stream heuristics, adds SP-GiST amgetbatch support, and introduces INDEX_PAGES_LIMIT. Logical replication work spans a conflict log history table under active review and a publication EXCEPT-clause edge case resolved without code change. Row Pattern Recognition reports 98.4% line coverage and clean Valgrind results. REPACK CONCURRENTLY received a minor stale-comment cleanup. Most threads remain open with unresolved implementation questions around memory layout, API correctness, and permission checks.

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]

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

The discussion concerns a proposed conflict log history table (CLT) for logical replication in PostgreSQL. Dilip Kumar merged patches from Amit Kapila and Nisha Moond and confirme…

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

Henson Choi posted two follow-up reports on the Row Pattern Recognition (RPR) patch. The first covers an updated code coverage analysis: modified-line coverage improved from 96.5%…

Read Discussion

This Week's Industry Movements

Amazon is opening its AI chips to third-party data centers, targeting a $50 billion market and challenging Nvidia's dominance. Groq confirmed a $650 million raise to stay independent after a notable Nvidia deal fell through. SpaceX signed a $150 million per month compute contract with Reflection AI through 2029. Anthropic launched Claude Tag for Slack, embedding persistent AI context capture into enterprise workflows.

Amazon Seeks to Sell Its AI Chips to External Data Centers, Challenging Nvidia

techcrunch.com

Amazon Seeks to Sell Its AI Chips to External Data Centers, Challenging Nvidia

AWS is in talks to sell its proprietary AI chips to third-party data centers, a move that positions Amazon more directly against Nvidia in the AI hardware market. CEO Andy Jassy h…

Groq Confirms $650M Funding Round After Nvidia's Not-Acqui-Hire Deal

techcrunch.com

Groq Confirms $650M Funding Round After Nvidia's Not-Acqui-Hire Deal

AI chipmaker Groq has confirmed a $650 million funding raise following a high-profile not-acqui-hire deal with Nvidia valued at $20 billion. Rather than being absorbed, Groq is le…

SpaceX Signs $150M/Month Compute Deal with Open-Source AI Lab Reflection AI

techcrunch.com

SpaceX Signs $150M/Month Compute Deal with Open-Source AI Lab Reflection AI

SpaceX has signed a major compute agreement with Reflection AI, an open-source AI lab. Under the deal, Reflection AI will pay $150 million per month starting July 1, 2026, through…

Anthropic's Claude Tag Brings Always-On AI to Slack for Enterprise Context Capture

techcrunch.com

Anthropic's Claude Tag Brings Always-On AI to Slack for Enterprise Context Capture

Anthropic has launched Claude Tag, a new feature that integrates its AI model directly into Slack as a persistent, always-on teammate. Beyond boosting individual productivity, Cla…

Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus to learn more