PostgreSQL 18: the features worth knowing about
The latest release brings native JSON path indexes, asynchronous I/O, and a dramatically improved query planner.
PostgreSQL 18 is the most significant release in years, with features that address long-standing pain points for developers building modern applications.
Native JSON path indexes
You can now create indexes on JSON path expressions directly, without needing to create generated columns. This makes PostgreSQL's JSON support competitive with MongoDB for document-style queries while keeping all the benefits of a relational database.
Async I/O
The new asynchronous I/O subsystem reduces query latency by up to 40% for I/O-bound workloads. This is especially impactful for analytical queries that scan large tables.
Dev Tools Editor
Developer tools editor and open source advocate. Writes about frameworks, languages, and the culture of building software. Contributor to several popular OSS projects.
Liked this? You will love the briefing.
One email. Every morning. The tech that matters.