PGNexus Weekly News This Week in PostgreSQL This week: PostgreSQL's 40-year staying power gets a fresh look as AI adoption grows. TimescaleDB 2.30 delivers a 14,000x query planning speedup for LIMIT queries. A real-world migration cut query latency 25x and compressed 1.7TB to 39GB. Fujitsu's enterprise buyer's guide helps teams evaluate database migration tooling beyond vendor demos, focusing on PostgreSQL as the target platform. [image: Why a 40-Year-Old Database Is Still Winning in the AI Era] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fw...> Sep 01, 2026 | Ajay Kulkarni Why a 40-Year-Old Database Is Still Winning in the AI Era <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fw...> PostgreSQL, now 40 years old, continues to dominate even as AI reshapes software development. Industry analysts and engineers attribute this to its foundational strengths: transac… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fw...> [image: 14,000x Faster Planning for LIMIT Queries on Hypertables] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ff...> Aug 27, 2026 | Sven Klemm 14,000x Faster Planning for LIMIT Queries on Hypertables <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ff...> TimescaleDB 2.30 introduces `DeferredChunkAppend`, a custom scan node that eliminates the per-chunk planning overhead for `LIMIT` queries on hypertables. Previously, queries like… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ff...> [image: How Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fc...> Aug 31, 2026 | Tristan Vermeesch How Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fc...> Companion.energy migrated real-time energy sensor telemetry from Azure PostgreSQL with a limited Apache 2 TimescaleDB extension to Tiger Cloud's fully featured managed TimescaleDB… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fc...> [image: Database migration tools: An enterprise buyer's guide] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Aug 31, 2026 | Fujitsu Database migration tools: An enterprise buyer's guide <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Enterprise database migration tools often appear comparable in feature matrices, but real differences surface under production conditions: stored procedures that resist automated… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Top 5 Hacker Discussions Discussions this period center on logical replication correctness and extensibility. The conflict log history table patch (v73) uncovered multiple bugs: incorrect size-expansion assumptions during JSON conversion, a 1 GB string limit crash from oversized jsonb values, and numeric type omission failures. EXCEPT clause semantics for schema-based publications remain unresolved, particularly around cross-schema partition and inheritance interactions. REPACK CONCURRENTLY slips to PG20. A row pattern recognition patch addresses pg_get_viewdef() column name ambiguity via a new set_define_names() mechanism. Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> The discussion centers on patch v73-0002 for a conflict log history table in logical replication. Dilip Kumar updated the patch after offlist testing revealed that the earlier ass… 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...> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Henson Choi shares a work-in-progress patch related to the row pattern recognition series (after v51) that addresses a name-ambiguity bug in `pg_get_viewdef()`. The problem arises… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> 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 <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> Support EXCEPT for TABLES IN SCHEMA publications <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABLE...> 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 <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABLE...> This Week's Industry Movements Anthropic's self-improving AI system corrected misaligned behaviors across all 10 benchmarks without hurting overall performance. Nvidia made a $3.5B bet on MediaTek to stay central as Big Tech builds custom chips. Over 100 companies including OpenAI and Google united against rogue AI cyber threats. Meanwhile, open-weight AI firms are becoming Silicon Valley's hottest acquisition targets, signaling a strategic shift toward openness as a competitive platform asset. [image: Anthropic Researcher Demonstrates Self-Improving AI System] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Anthropic Researcher Demonstrates Self-Improving AI System <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> An Anthropic researcher has revealed early results from a self-improving AI system. Given 10 benchmarks targeting specific misaligned behaviors, the automated system improved perf… [image: Nvidia's $3.5B Investment in MediaTek to Counter Big Tech's Custom AI Chips] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Nvidia's $3.5B Investment in MediaTek to Counter Big Tech's Custom AI Chips <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Nvidia has invested $3.5 billion into Taiwanese chipmaker MediaTek, signaling a strategic move to stay central to AI infrastructure as major tech companies increasingly develop th… [image: OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Some of the world's largest tech companies and AI startups — including OpenAI, Anthropic, and Google — have jointly called for action to address growing cybersecurity threats pose… [image: Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> According to TechCrunch, open-weight AI companies have become among the most sought-after acquisition targets in Silicon Valley. Significant capital is flowing into businesses tha… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more