What's New in PostgreSQL 14?

PostgreSQL 14, released on September 30, 2021, brings several new features and performance enhancements, notably easier manipulation of JSON data with jsonb subscripting and the introduction of multirange data types, which allow storage of multiple non-contiguous ranges as a single entity. These updates improve on previous versions by enhancing the efficiency of querying nested JSON structures and simplifying data storage, such as for meeting schedules that include breaks, without requiring multiple database rows. Additionally, PostgreSQL 14 offers significant improvements in handling concurrent connections, showing up to a 50% increase in throughput at higher connection volumes, which is particularly beneficial for applications with high client connections. Render, a cloud service provider, was immediately supportive of this new PostgreSQL version, offering users quick access to these advancements, allowing developers to concentrate on their applications while Render manages the underlying infrastructure.