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%2Fh...> 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%2Fh...> 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%2Fh...> [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%2Fag...> 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%2Fag...> 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%2Fag...> 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%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 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%2F...> 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%2F...> 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%2F...> techcrunch.com Anthropic Updates Claude Voice Mode with More Capable Models <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> 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%2F...> 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%2F...> 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%2F...> 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