PGNexus Weekly News |
This Week in PostgreSQLThis 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. |
Top 5 Hacker DiscussionsLogical 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. |
This Week's Industry MovementsAlabama 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. |
|
Want to stay up to date with the PostgreSQL community and industry news?
|