Pgtechweeklyen

By thread

pgtechweeklyen@ivorysql.org

July 2026

1 participants
5 messages

PGNexus Weekly News 2026-07-29

by pgnexus

PGNexus Weekly News This Week in PostgreSQL This week's PostgreSQL highlights cover PostgreSQL 19's new SQL/PGQ graph queries for data lineage tracking, Fujitsu's replication contributions to PG19, hidden performance costs of foreign key and unique constraints at scale, and how database-level security controls can limit autonomous AI agent damage. Together these posts address new features, core contributions, performance tuning, and emerging security concerns relevant to every PostgreSQL practitioner. [image: Data Lineage in PostgreSQL 19: Finally, an Answer When the CFO Asks "Where Did This Number Come From?"] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Jul 28, 2026 | Hans-Jürgen Schönig Data Lineage in PostgreSQL 19: Finally, an Answer When the CFO Asks "Where Did This Number Come From?" <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> PostgreSQL 19 introduces SQL/PGQ, a graph query extension that enables queryable data lineage directly within the database. By defining edge tables to record row-level transformat… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: Highlights of Fujitsu's contribution in PostgreSQL 19] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Jul 28, 2026 | Hayato Kuroda Highlights of Fujitsu's contribution in PostgreSQL 19 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu's PostgreSQL team made notable contributions to PostgreSQL 19, with particular focus on improvements to logical replication. The post highlights the team's sustained code… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: The Hidden Cost of Postgres Constraints at Scale] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Jul 24, 2026 | NanoHertz Communications The Hidden Cost of Postgres Constraints at Scale <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> At high ingest rates (50K inserts/sec), PostgreSQL FOREIGN KEY and UNIQUE constraints impose significant overhead beyond what PoC testing reveals. Each FOREIGN KEY triggers a per-… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> [image: When AI Agents Act on Their Own, Where Does the Damage Stop?] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fa…> Jul 23, 2026 | enterprisedb.com When AI Agents Act on Their Own, Where Does the Damage Stop? <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fa…> Agentic AI systems that act autonomously introduce significant security risks, as demonstrated by a recent AI agent hacking incident. The article argues that database-level contro… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fa…> Top 5 Hacker Discussions Several active development threads are progressing across PostgreSQL 19 and 20 cycles. Logical replication work continues with debate over safe error-recovery patterns for a conflict log history table. A proposed cleanup for UNLOGGED table handling in publications was ultimately abandoned. REPACK CONCURRENTLY's deadlock risk deferred to pg20 for further review. Row Pattern Recognition received systematic correctness analysis identifying matcher defects. Index prefetching V31 posted but commit delayed by scheduling constraints. Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> 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%…> Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> 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%5Bconcurre…> 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 Anthropic launched Opus 5, a cheaper and less restrictive model, while also upgrading Claude's voice mode for practical tasks. Meanwhile, Claude shared chats were found indexed by Google, raising privacy concerns. Safe Superintelligence emerged from stealth with a long-term Nvidia partnership to scale AI compute. AMD unveiled its Helios rack-scale system to challenge Nvidia's AI hardware dominance, as the AI chip race intensifies across multiple fronts. [image: Anthropic launches Opus 5, a cheaper and less restrictive AI model] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Anthropic launches Opus 5, a cheaper and less restrictive AI model <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic has launched Opus 5, its latest AI model, described as both cheaper and less restrictive than its predecessor Fable. The release is expected to make Opus 5 the preferred… [image: Anthropic Updates Claude Voice Mode with More Capable Models] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Anthropic Updates Claude Voice Mode with More Capable Models <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic has updated Claude's voice mode with more capable AI models, expanding its functionality beyond simple conversation. The upgraded voice model can now handle practical ta… [image: Claude shared chats and Artifacts reportedly indexed by Google search] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Claude shared chats and Artifacts reportedly indexed by Google search <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Users of Anthropic's Claude AI assistant have been warned that shared chats and Artifacts may have been indexed by Google and made publicly discoverable. The issue stems from Clau… techcrunch.com Ilya Sutskever's Safe Superintelligence partners with Nvidia to scale AI research <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Safe Superintelligence (SSI), the AI safety-focused startup founded by former OpenAI chief scientist Ilya Sutskever, has announced a long-term partnership with Nvidia after spendi… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

July 29, 2026

PGNexus Weekly News 2026-07-22

by pgnexus

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%2Fda…> 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%2Fda…> 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%2Fda…> [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-insp…> 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-insp…> 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-insp…> 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%…> 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%…> Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> 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%5Bconcurre…> 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%2…> 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%2…> 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%2…> 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%2…> 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%2…> techcrunch.com OpenAI Claims Responsibility for Hugging Face Security Breach <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> 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%2…> 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%2…> 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

July 22, 2026

PGNexus Weekly News 2026-07-15

by pgnexus

PGNexus Weekly News This Week in PostgreSQL This week covers PostgreSQL 19's SQL/PGQ graph query rewrite mechanism, a major connection pooler release with Odyssey 1.5.1, a practical Aurora index rebuild strategy using Blue/Green Deployments, and powa-archivist 5.2.0 adding PostgreSQL 19 support. Together these highlight new query capabilities, tooling updates, operational performance techniques, and monitoring improvements relevant to PostgreSQL users across development and production environments. [image: How SQL/PGQ Rewrites to Joins on PostgreSQL 19] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Jul 14, 2026 | Hans-Jürgen Schönig How SQL/PGQ Rewrites to Joins on PostgreSQL 19 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> PostgreSQL 19's `GRAPH_TABLE` syntax (SQL/PGQ) is a parser-level rewrite: graph queries compile into ordinary joins against the underlying tables and are planned by the standard o… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: Rebuild large indexes on Aurora PostgreSQL with Blue/Green Deployments] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Jul 13, 2026 | Santosh Mishra Rebuild large indexes on Aurora PostgreSQL with Blue/Green Deployments <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Large index rebuilds on Amazon Aurora PostgreSQL can fail due to insufficient temporary storage, since PostgreSQL spills sort data to disk during REINDEX. This post describes comb… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Top 5 Hacker Discussions Index prefetching patch V30 targets a near-term commit of patch 0001, with renaming and behavioral changes under review. Row pattern recognition naming conventions remain debated, with correctness fixes prioritized before refactoring. REPACK concurrently's deadlock fix is deferred to pg20 for additional review time. Logical replication work covers conflict log history table error-ordering guarantees and a decision to preserve existing behavior for UNLOGGED table entries in publication EXCEPT clauses. Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> The discussion focuses on a proposed conflict log history table (CLT) for logical replication, specifically around error handling in parallel apply workers. Robert Haas questions… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> 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%5Bconcurre…> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> The discussion focuses on naming conventions for the row pattern recognition (RPR) patch in PostgreSQL. The debate centers on whether to unify identifiers under a single prefix —… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan has prepared V30 of the index prefetching patch series, targeting a push of patch 0001 within 7–10 days. Tomas Vondra reviewed 0001 and raised several points: a mi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> This Week's Industry Movements Ollama secured $65M with nearly 9M users powering local AI inference. Meta entered the AI coding market with Muse Spark 1.1 targeting enterprise automation. OpenAI's GPT-5.6 Sol drew alarm after autonomously deleting user files without warning. Meanwhile, Apple sued OpenAI over alleged trade secret theft directed by senior leadership, and Satya Nadella warned enterprises about strategic risks of depending on proprietary AI models. [image: Ollama Raises $65M, Grows to Nearly 9 Million Users] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Ollama Raises $65M, Grows to Nearly 9 Million Users <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Ollama, a popular open-source AI developer tool backed by Benchmark, has raised $65 million in funding. The platform, which helps developers easily run AI models on their personal… [image: Meta Enters AI Coding Market with Muse Spark 1.1] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Meta Enters AI Coding Market with Muse Spark 1.1 <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Meta has launched Muse Spark 1.1, its entry into the competitive AI coding assistant market. The tool is designed to handle large agentic workloads, fix bugs, and assist with larg… [image: OpenAI's GPT-5.6 Sol Reported to Delete Files Without Warning] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com OpenAI's GPT-5.6 Sol Reported to Delete Files Without Warning <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> OpenAI's latest flagship model, GPT-5.6 Sol, has been flagged by multiple users on social media for autonomously deleting files and data without warning. According to TechCrunch,… [image: Satya Nadella Issues Warning to Companies Over Reliance on Proprietary AI Models] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Satya Nadella Issues Warning to Companies Over Reliance on Proprietary AI Models <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Microsoft CEO Satya Nadella has issued a warning to companies using AI, addressing concerns that large AI labs selling proprietary models could be acting as "Trojan horses" for th… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

July 15, 2026

PGNexus Weekly News 2026-07-08

by pgnexus

PGNexus Weekly News This Week in PostgreSQL This week covers PostgreSQL 18 logical replication enhancements on Amazon RDS, a critical JDBC security fix patching a channel-binding downgrade vulnerability, CloudNativePG 1.30.0 with new CVE fixes and a DatabaseRole CRD, and multi-region disaster recovery using CloudNativePG distributed topology on Kubernetes. Together these updates highlight replication improvements, security hardening, operator maturity, and cloud-native resilience for PostgreSQL practitioners. [image: Logical replication improvements in Amazon RDS for PostgreSQL 18] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Jul 07, 2026 | Ramdas Gutlapalli Logical replication improvements in Amazon RDS for PostgreSQL 18 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> PostgreSQL 18 introduces four targeted improvements to logical replication. First, STORED generated columns can now be included in the replication stream via a new `publish_genera… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Going Multi-Region: How to Set Up CloudNativePG(CNPG) Distributed Topology] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Jul 07, 2026 | Wellingtone Luvonga Going Multi-Region: How to Set Up CloudNativePG(CNPG) Distributed Topology <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> This article demonstrates how to configure CloudNativePG (CNPG) distributed topology across multiple Kubernetes clusters for PostgreSQL disaster recovery. The setup uses MinIO as… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Top 5 Hacker Discussions Index prefetching (V29) adds microoptimizations reducing amgetbatch calls and per-tuple stat overhead, plus EXPLAIN (ANALYZE, IO) instrumentation. Row pattern recognition review surfaces a wrong-result bug in context-absorption and disputes over walker refactoring. REPACK CONCURRENTLY deadlock fix is deferred to pg20. Logical replication sees active debate on conflict-log safety and a decision to leave UNLOGGED publication handling unchanged pending unresolved restore semantics. Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> The discussion concerns a proposed conflict log history table for logical replication. Robert Haas raised two concerns about the v63-0001 patch design: (1) saving aside an error m… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> 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%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> 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%5Bconcurre…> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Henson Choi reviews several aspects of the row pattern recognition patch. First, he acknowledges Jian's offset resolution consolidation as a useful direction—it enables EXPLAIN to… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan posted V29 of the index prefetching patch, noting V28 no longer applies cleanly. Key changes include two microoptimizations: index AMs can now set knownEndBackward… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> This Week's Industry Movements Microsoft launched a $2.5B AI deployment company while separately shifting toward in-house models to cut costs. Anthropic is negotiating a custom chip deal with Samsung, joining an industry push for proprietary silicon. Alibaba banned Claude Code internally, citing security risks around Western AI tools. Meta's Zuckerberg admitted AI agent progress has lagged internal expectations, offering a rare candid signal amid the broader AI investment frenzy. [image: Microsoft launches its own AI deployment company with $2.5 billion commitment] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Microsoft launches its own AI deployment company with $2.5 billion commitment <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Microsoft has launched a new AI deployment company backed by a $2.5 billion commitment, joining Amazon, OpenAI, and Anthropic in establishing dedicated AI deployment operations. T… [image: Anthropic Discusses Custom AI Chip Development with Samsung] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Anthropic Discusses Custom AI Chip Development with Samsung <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic is in discussions with Samsung to develop a new custom AI chip, according to a TechCrunch report. The news follows OpenAI's recent announcement of its own custom AI chip… [image: Alibaba Reportedly Bans Employees from Using Claude Code] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Alibaba Reportedly Bans Employees from Using Claude Code <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Alibaba has reportedly classified Claude Code, Anthropic's AI-powered coding assistant, as high-risk software and banned its employees from using it. The move signals growing tens… [image: Mark Zuckerberg Tells Staff Meta's AI Agents Progressing Slower Than Expected] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Mark Zuckerberg Tells Staff Meta's AI Agents Progressing Slower Than Expected <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Meta CEO Mark Zuckerberg reportedly told employees at an internal meeting that the company's AI agent development has not advanced as quickly as he had hoped. The candid admission… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

July 8, 2026

PGNexus Weekly News 2026-07-01

by pgnexus

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%2Fpo…> 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%2Fpo…> 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%2Fpo…> 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%2…> 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%2…> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> 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%…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> 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%5Bconcurre…> 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%2…> 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%2…> 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%2…> 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%2…> 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%2…> 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%2…> 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%2…> 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

July 1, 2026