Company
Date Published
Author
Bryan Clark
Word count
1942
Language
English
Hacker News points
None

Summary

Postgres 18 has been released with a variety of enhancements aimed at improving performance, flexibility, and the developer experience, and is immediately available for preview on the Neon platform. Key features include B-tree skip scans for more efficient query processing, improved EXPLAIN output for better query optimization, and virtual generated columns that don't increase table size. The update also introduces native UUIDv7 support for improved index performance, an expanded RETURNING clause for capturing old and new row values, and temporal constraints for maintaining integrity in time-based data. Additionally, Postgres 18 supports OAuth authentication and introduces asynchronous I/O for read operations, enhancing throughput by allowing multiple reads to occur simultaneously. The release also brings refined autovacuum maintenance configuration and parallel GIN index builds to boost indexing performance. While Neon is currently optimizing its backend to fully integrate these new features, users are encouraged to try Postgres 18 on Neon's Free plan, with full production readiness expected once the preview phase concludes.