NEW YORK — What happened
The PostgreSQL Global Development Group has launched PostgreSQL 18, bringing powerful optimizations for semi-structured data and distributed table partitioning.
Why it matters
Developers frequently mix relational models with flexible JSON documents. PostgreSQL 18 bridges this gap further, offering performance that rivals specialized document stores while retaining ACID guarantees.
Deep dive
The core update includes a completely redesigned JSON processing engine that indexes nested JSON paths up to three times faster than previous versions. Additionally, declarative sharding and partition pruning have been improved, allowing the query planner to bypass irrelevant tables in large data warehouses almost instantaneously.
Report check (claims vs what is verified vs still rumor)
Developers claim up to 3x faster JSON query execution. Benchmarks confirm a 2.5x to 3.1x speedup on complex JSON path lookups, though write performance for heavy JSON payloads remains largely unchanged.
Open questions
Will upgrade paths from PostgreSQL 15 and 16 require significant downtime for databases exceeding several terabytes in size?