PGNexus Daily News PostgreSQL Technical Articles [image: Just landed in the Neon CLI] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fjust-lande...> Carlota Soto Just landed in the Neon CLI <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fjust-lande...> The Neon CLI has received several updates over recent months, with a focus on enabling agent-driven workflows that operate without manual console interaction. The tool is position… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fjust-lande...> [image: Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Frep...> Pablo Svampa Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Frep...> A PostgreSQL standby on an EC2 instance using Amazon FSx over NFS experienced persistent replication lag. Despite FSx operating at roughly 50% of provisioned throughput and IOPS,… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Frep...> [image: Building AI-ready data on an enterprise PostgreSQL foundation] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Fujitsu Building AI-ready data on an enterprise PostgreSQL foundation <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Fujitsu's post examines the gap between AI pilots and production deployment in large enterprises. While most organizations have some AI initiative underway by 2026, moving prototy… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> [image: pg_statviz 1.2 released with PostgreSQL 19 support and new features] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> www.postgresql.org pg_statviz 1.2 released with PostgreSQL 19 support and new features <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> pg_statviz 1.2 has been released with PostgreSQL 19 support, tested through beta3 and compatible with versions 13–19. New features include capture of the `wal_fpi_bytes` counter f… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> [image: Why We Aren't Ready for C-3PO] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fw...> Matty Stratton Why We Aren't Ready for C-3PO <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fw...> The article argues that AI reasoning for robotics has advanced rapidly, while physical challenges, dexterity, reliability, and training data, remain the primary bottlenecks. Model… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fw...> PostgreSQL Hackers Email Discussion Highlights tablecmds: fix bug where index rebuild loses replica identity on partitions <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20whe...> Sami Imseih reviewed Melanie's patches fixing a bug where index rebuilds during ALTER COLUMN TYPE or ALTER COLUMN SET EXPRESSION lose properties (replica identity, cluster-on mark… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20whe...> SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row <https://pgnexus.ai/hacker-discussions?subject=SSI%3A%20ON%20CONFLICT%20DO%20...> The discussion concerns a bug in Serializable Snapshot Isolation (SSI) where `ON CONFLICT DO SELECT` fails to acquire a predicate lock on the returned row, potentially compromisin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SSI%3A%20ON%20CONFLICT%20DO%20...> scary patch contest <https://pgnexus.ai/hacker-discussions?subject=scary%20patch%20contest> Robert Haas used Claude to identify the riskiest v19 patches based on post-freeze bug counts. The top concerns are: (1) RI fast-path FK checks/batching (~16 fixes, including incor… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=scary%20patch%20contest> Assertion failure in GetSubscriptionRelations() with concurrent DROP TABLE <https://pgnexus.ai/hacker-discussions?subject=Assertion%20failure%20in%20Get...> The discussion addresses an assertion failure in `GetSubscriptionRelations()` triggered by concurrent `DROP TABLE` in logical replication. The proposed fix (by Vignesh) handles th… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Assertion%20failure%20in%20Get...> RegisterShmemCallbacks() does nothing in single-user mode <https://pgnexus.ai/hacker-discussions?subject=RegisterShmemCallbacks()%20doe...> Ayush Tiwari reported that `RegisterShmemCallbacks()` silently does nothing in single-user mode due to the `IsUnderPostmaster` guard in commit 283e823f9dc. Extensions loaded at ru… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=RegisterShmemCallbacks()%20doe...> Changing client-side behavior regarding Certificate Revocation Lists (CRL) <https://pgnexus.ai/hacker-discussions?subject=Changing%20client-side%20behav...> Михаил Купцов proposed changing psql's client-side behavior so that specifying an incorrect path to a CRL file or directory results in an error rather than silently proceeding wit… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Changing%20client-side%20behav...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-25-postgresql-daily-news-249.m...> Industry News [image: Anthropic's Claude Cowork Gains Shared Memory Across Chat Sessions] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Anthropic's Claude Cowork Gains Shared Memory Across Chat Sessions <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Anthropic is rolling out a shared memory feature for Claude, enabling the AI to retain context across both its chat interface and Cowork environment. Previously, users had to repe… [image: SpaceX Plans $100B Second 'Starbase' Spaceport in Louisiana] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com SpaceX Plans $100B Second 'Starbase' Spaceport in Louisiana <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> SpaceX has announced plans to build a second Starbase spaceport in Louisiana, with an estimated investment of $100 billion. Construction is set to begin in 2027, and the company e… [image: Self-Driving Truck Startup Gatik Raises $200M Following PepsiCo Deal] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Self-Driving Truck Startup Gatik Raises $200M Following PepsiCo Deal <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Autonomous trucking startup Gatik has raised $200 million in its largest funding round to date, following a commercial deal with PepsiCo. The round was led by Qatar Investment Aut… Social Media Updates [image: Meet Yashwant Lakhera 🎬 Our Motion Designer & Video Creator who turns ideas into scroll-stopping visuals.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Meet Yashwant Lakhera 🎬 Our Motion Designer & Video Creator who turns ideas into scroll-stopping visuals. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> CYBERTEC introduces Yashwant Lakhera, a Motion Designer and Video Creator on their team. His work spans motion graphics and brand storytelling, and he is contributing to how CYBER… [image: VLDB 2026 Program Spotlight: Keynotes] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Ffeed%2F...> linkedin VLDB 2026 Program Spotlight: Keynotes <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Ffeed%2F...> VLDB 2026 will feature two keynote talks on the evolution and future of data systems. Reynold Xin from Databricks will speak on September 1 about the three golden ages of database… linkedin 40,000+ attendees. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Data + AI World Tour is a global event series spanning 20 cities, beginning in September. It offers a full day of sessions focused on new ideas, technical learning, and hands-on e… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more