PostgreSQL 14 Released!
PostgreSQL 14 brings a variety of features that help developers and administrators deploy their data-backed applications. PostgreSQL continues to add innovations on complex data types, including more convenient access for JSON and support for noncontiguous ranges of data. This latest release adds to PostgreSQL's trend on improving high performance and distributed data workloads, with advances in connection concurrency, high-write workloads, query parallelism and logical replication.
Features:
- JSON Conveniences and Multiranges:
SELECT ('{ "postgres": { "release": 14 }}'::jsonb)['postgres']['release']; now works.- Performance Improvements for Heavy Workloads
- Enhancements for Distributed Workloads
- Administration and Observability
- SQL Performance, Conformance, and Convenience
https://www.postgresql.org/about/news/postgresql-14-released-2318/