PostgreSQL 17 Announced
Version 17 of the PostgreSQL open source database has been released with notable improvements in performance and functionality.
The performance-related updates include:
- A new internal memory structure for vacuum, which consumes up to 20x less memory, improving speed and reducing the use of shared resources.
- Improved performance of its I/O layer, meaning “high concurrency workloads may see up to 2x better write throughput.”
- A new streaming I/O interface that “speeds up sequential scans.”
- Improved query execution performance of indexes.
PostgreSQL 17 also includes enhancements for managing data in partitions as well as data distributed across remote PostgreSQL instances and new functionality such as the JSON_TABLE command, which lets developers convert JSON data into a standard PostgreSQL table.
Read more at PostgreSQL.
Want to learn more about the open source database ecosystem? Check out this ADMIN
focus guide available free for a limited time. Download it now!
10/04/2024
Related content
- PostgreSQL 15 Released
- PostgreSQL 16 Beta Now Available
-
What's new in PostgreSQL 9.4
The PostgreSQL Global Development Group recently introduced the new major version 9.4 of the popular free database, which includes innovative functions as well as a whole range of changes regarding speed and functionality. -
New in PostgreSQL 9.3
The new PostgreSQL 9.3 release introduces several speed and usability improvements, as well as SQL standards compliance. - A Quick Guide to Setting Up PostgreSQL