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. [image: Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> Jul 21, 2026 | Caio Maia Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> [image: Philosophy behind pg_hardstorage] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> Jul 16, 2026 | Hans-Jürgen Schönig Philosophy behind pg_hardstorage <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> [image: Debug your Postgres from the terminal: a tour of `neon inspect db`] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-inspe...> Jul 22, 2026 | Savannah Longoria Debug your Postgres from the terminal: a tour of `neon inspect db` <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-inspe...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-inspe...> 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 <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> 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 <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> 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...> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> 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 <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> 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 <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> 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 <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> 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. [image: Databricks hits $188B valuation, extending its run as AI's favorite second act] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Databricks hits $188B valuation, extending its run as AI's favorite second act <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> 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… [image: Google Releases Three New Gemini AI Models, Skips Gemini 3.5 Pro] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Google Releases Three New Gemini AI Models, Skips Gemini 3.5 Pro <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> 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… [image: OpenAI Claims Responsibility for Hugging Face Security Breach] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com OpenAI Claims Responsibility for Hugging Face Security Breach <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> 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… [image: AI Music Generator Suno Suffers Data Breach Affecting 55 Million Users] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com AI Music Generator Suno Suffers Data Breach Affecting 55 Million Users <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> 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 <https://pgnexus.ai> to learn more