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.

Why a 40-Year-Old Database Is Still Winning in the AI Era

Sep 01, 2026 | Ajay Kulkarni

Why a 40-Year-Old Database Is Still Winning in the AI Era

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
14,000x Faster Planning for LIMIT Queries on Hypertables

Aug 27, 2026 | Sven Klemm

14,000x Faster Planning for LIMIT Queries on Hypertables

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
How Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud

Aug 31, 2026 | Tristan Vermeesch

How Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud

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
Database migration tools: An enterprise buyer's guide

Aug 31, 2026 | Fujitsu

Database migration tools: An enterprise buyer's guide

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

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

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
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
Row pattern recognition

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
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
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

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.

Anthropic Researcher Demonstrates Self-Improving AI System

techcrunch.com

Anthropic Researcher Demonstrates Self-Improving AI System

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…

Nvidia's $3.5B Investment in MediaTek to Counter Big Tech's Custom AI Chips

techcrunch.com

Nvidia's $3.5B Investment in MediaTek to Counter Big Tech's Custom AI Chips

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…

OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats

techcrunch.com

OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats

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…

Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets

techcrunch.com

Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets

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