PGNexus Daily News

PostgreSQL Technical Articles

Just landed in the Neon CLI

Carlota Soto

Just landed in the Neon CLI

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
Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit

Pablo Svampa

Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit

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
Building AI-ready data on an enterprise PostgreSQL foundation

Fujitsu

Building AI-ready data on an enterprise PostgreSQL foundation

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
pg_statviz 1.2 released with PostgreSQL 19 support and new features

www.postgresql.org

pg_statviz 1.2 released with PostgreSQL 19 support and new features

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
Why We Aren't Ready for C-3PO

Matty Stratton

Why We Aren't Ready for C-3PO

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

PostgreSQL Hackers Email Discussion Highlights

tablecmds: fix bug where index rebuild loses replica identity on partitions

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
SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row

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
scary patch contest

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
Assertion failure in GetSubscriptionRelations() with concurrent DROP TABLE

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
RegisterShmemCallbacks() does nothing in single-user mode

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
Changing client-side behavior regarding Certificate Revocation Lists (CRL)

Михаил Купцов 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

Click here for the full Hacker discussion highlights

 

Industry News

Anthropic's Claude Cowork Gains Shared Memory Across Chat Sessions

techcrunch.com

Anthropic's Claude Cowork Gains Shared Memory Across Chat Sessions

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…

SpaceX Plans $100B Second 'Starbase' Spaceport in Louisiana

techcrunch.com

SpaceX Plans $100B Second 'Starbase' Spaceport in Louisiana

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…

Self-Driving Truck Startup Gatik Raises $200M Following PepsiCo Deal

techcrunch.com

Self-Driving Truck Startup Gatik Raises $200M Following PepsiCo Deal

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

Meet Yashwant Lakhera 🎬 Our Motion Designer & Video Creator who turns ideas into scroll-stopping visuals.

linkedin

Meet Yashwant Lakhera 🎬 Our Motion Designer & Video Creator who turns ideas into scroll-stopping visuals.

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…

VLDB 2026 Program Spotlight: Keynotes

linkedin

VLDB 2026 Program Spotlight: Keynotes

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.

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 to learn more