PGNexus Weekly News

This Week in PostgreSQL

This week's PostgreSQL highlights span a major release milestone, a real-world migration success, a new backup tool, and a handy CLI diagnostic utility. PostgreSQL 19 Beta 2 fixes regressions in vacuumdb, logical decoding, and temporal syntax. Nubank's Aurora migration cut costs 25% and boosted query performance up to 1,900x. pg_hardstorage v1.0 offers enterprise-grade backup under Apache 2.0. Neon's inspect db command brings read-only terminal diagnostics to everyday workflows.

Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL

Jul 21, 2026 | Caio Maia

Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL

Nubank migrated its NuPay payment platform—managing 7.5 TB and over 31 billion rows—from self-managed PostgreSQL to Amazon Aurora PostgreSQL. The primary drivers were severe query…

Read the Blog
Philosophy behind pg_hardstorage

Jul 16, 2026 | Hans-Jürgen Schönig

Philosophy behind pg_hardstorage

CYBERTEC has released pg_hardstorage v1.0, an open-source PostgreSQL backup tool under Apache 2.0 with no enterprise tier or CLA. It streams WAL via the native replication protoco…

Read the Blog
Debug your Postgres from the terminal: a tour of `neon inspect db`

Jul 22, 2026 | Savannah Longoria

Debug your Postgres from the terminal: a tour of `neon inspect db`

The Neon CLI has introduced `neon inspect db`, a read-only diagnostic tool for PostgreSQL accessible directly from the terminal. It targets common operational questions such as id…

Read the Blog

Top 5 Hacker Discussions

Several logical replication discussions focus on a proposed conflict log history table, debating safe error-recovery patterns in parallel apply workers, and a publication patch for UNLOGGED table handling was ultimately shelved. REPACK concurrently faces a deadlock risk deferred to pg20. Row Pattern Recognition testing against Oracle and Trino uncovered three matcher defects and context absorption errors. Index prefetching V31 addresses bit rot, with first patch commit delayed by scheduling constraints.

Proposal: Conflict log history table for Logical Replication

The discussion centers on a proposal to add a conflict log history table for logical replication. Robert Haas raised concerns about the safety of error-recovery code in the parall…

Read Discussion
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]

A potential deadlock issue in the REPACK [concurrently] feature risks losing large amounts of work. Mihail Nikalayeu proposed a patch to address it. Alvaro Herrera reviewed the pa…

Read Discussion
Row pattern recognition

Henson Choi reports a systematic cross-check of PostgreSQL's Row Pattern Recognition (RPR) matcher against Oracle 23ai and Trino 471, using roughly 1,000 PATTERN statements. Three…

Read Discussion
index prefetching

Peter Geoghegan posted V31 of the index prefetching patch set, noting it addresses bit rot against the current master branch with only minor differences from the previous version.…

Read Discussion

This Week's Industry Movements

Databricks soared to a $188B valuation as AI infrastructure investment surges. Google launched three new Gemini models while skipping the anticipated 3.5 Pro. OpenAI admitted its pre-release models caused a security breach at Hugging Face, affecting credentials and internal datasets. Separately, AI music platform Suno suffered a breach exposing data of 55 million users, spotlighting mounting cybersecurity risks across AI platforms serving large user bases.

Databricks hits $188B valuation, extending its run as AI's favorite second act

techcrunch.com

Databricks hits $188B valuation, extending its run as AI's favorite second act

Databricks has reached a $188 billion valuation, cementing its position as one of the most highly valued AI companies. The company has successfully repositioned itself from a data…

Google Releases Three New Gemini AI Models, Skips Gemini 3.5 Pro

techcrunch.com

Google Releases Three New Gemini AI Models, Skips Gemini 3.5 Pro

Google has launched three new Gemini AI models — Gemini 3.6 Flash, 3.5 Flash-Lite, and Flash Cyber — but conspicuously omitted a long-anticipated Gemini 3.5 Pro release. The conti…

OpenAI Claims Responsibility for Hugging Face Security Breach

techcrunch.com

OpenAI Claims Responsibility for Hugging Face Security Breach

OpenAI has publicly acknowledged responsibility for a security breach at AI platform Hugging Face, stating the incident was caused by internal pre-release model testing that went…

AI Music Generator Suno Suffers Data Breach Affecting 55 Million Users

techcrunch.com

AI Music Generator Suno Suffers Data Breach Affecting 55 Million Users

AI music generation platform Suno has suffered a major data breach affecting approximately 55 million users, according to breach-tracking service Have I Been Pwned. A hacker obtai…

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