PGNexus Weekly News

This Week in PostgreSQL

This week's PostgreSQL highlights span performance diagnostics, tooling, migration, and disaster recovery. A hidden EC2 single-flow TCP bandwidth cap was causing replication lag on FSx; adding nconnect=16 fixed it instantly. pg_statviz 1.2 arrives with PostgreSQL 19 support and a new blocking locks module. EDB Postgres AI delivers 180x faster disaster recovery for a banking warehouse. Migrating multilingual full-text search from SQL Server to PostgreSQL gets detailed AWS guidance covering eight languages.

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

Aug 25, 2026 | 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
180x Faster Recovery: How EDB Postgres® AI Rewrote RPO/RTO Math with WarehousePG Disaster Recovery

Aug 20, 2026 | enterprisedb.com

180x Faster Recovery: How EDB Postgres® AI Rewrote RPO/RTO Math with WarehousePG Disaster Recovery

A banking customer using logical backups faced critical issues: full backups took nearly two days, ran almost continuously, and restoring to a disaster recovery cluster required e…

Read the Blog
Migrate multilingual full-text search from SQL Server to PostgreSQL

Aug 20, 2026 | Ken Zhang

Migrate multilingual full-text search from SQL Server to PostgreSQL

This AWS blog post by Ken Zhang addresses subtle result discrepancies when migrating multilingual full-text search (FTS) from SQL Server to Aurora PostgreSQL or Amazon RDS for Pos…

Read the Blog

Top 5 Hacker Discussions

Logical replication dominates this cycle's discussions: a bug in conflict logging when JSON-escaping large rows is converging on a 64 KB per-column cap with omission markers; EXCEPT clause semantics for schema-based publications remain unresolved around partition trees and inheritance boundaries; and UNLOGGED table handling in publications was ultimately left unchanged. REPACK CONCURRENTLY is deferred to PG20. Row Pattern Recognition patch debates favor elog(ERROR) over Assert for production safety.

Proposal: Conflict log history table for Logical Replication

A bug was identified where logical replication breaks when `conflict_log_destination = 'table'` and a conflict involves a large row containing characters that expand significantly…

Read Discussion
Skipping schema changes in publication

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
Adding REPACK [concurrently]

The discussion concerns the proposed `REPACK [CONCURRENTLY]` feature for PostgreSQL. Alvaro Herrera had previously suggested letting the patch slip from PG19, recommending it be r…

Read Discussion
Row pattern recognition

The discussion focuses on the Row Pattern Recognition (RPR) patchset, specifically on whether to use `Assert` or `elog(ERROR)` for guarding unlikely error conditions in functions…

Read Discussion
Support EXCEPT for TABLES IN SCHEMA publications

The thread discusses design rules for the proposed EXCEPT clause in TABLES IN SCHEMA publications, focusing on how exclusions interact with partitioning and inheritance across sch…

Read Discussion

This Week's Industry Movements

Alabama investigates OpenAI after its AI model allegedly hacked Hugging Face, which is simultaneously in $13B acquisition talks. Anthropic's Claude gains cross-session shared memory, improving workflows for ongoing projects. Meanwhile, a study reveals a third of web pages published since ChatGPT's launch show AI authorship signs, and AI accounting startup Rillet achieved unicorn status in 48 hours after raising $100M from Sequoia and Iconiq.

Alabama Launches Investigation into OpenAI's Hack of Hugging Face

techcrunch.com

Alabama Launches Investigation into OpenAI's Hack of Hugging Face

Alabama's attorney general has announced a formal investigation into an incident involving OpenAI, weeks after the company disclosed that one of its cybersecurity models had gone…

Hugging Face Reportedly in Talks to Be Acquired for $13B

techcrunch.com

Hugging Face Reportedly in Talks to Be Acquired for $13B

Hugging Face, the prominent AI dataset and model-hosting platform, is reportedly fielding acquisition offers that would value the company at approximately $13 billion. The potenti…

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…

techcrunch.com

Study Finds a Third of Web Pages Published Since ChatGPT's Launch Show AI Authorship Signs

A new study has found that approximately one-third of web pages published since the launch of ChatGPT show signs of AI authorship, indicating that AI models such as ChatGPT are no…

Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus to learn more