Скачать или смотреть POSTGRESQL 17 RELEASE

PostgreSQL 17 was released in September 2024, and updates to the current version will be delivered until November 2029. The main additions and changes to the project are as follows:

New features for working with JSON have been added. If we talk directly about functionality, there is a new jsonpath operator so that you can convert data from native format to PostgreSQL, in addition, JSON-TABLE function became available, which is necessary for converting data to PostgreSQL. New functions for querying and creating JSON format data have also been introduced;
The approach in the data structure of the VACUUM operation has been changed. Now during the execution of the operation less resources will be used and thus the execution speed will be increased;
If a B-tree-based index is used in a query with IN in such a variant, the efficiency will be significantly improved. Parallel construction will be available in BRIN indexes. CTE processing when using WITH command is slightly accelerated, and NOT NULL queries are also optimized. SIMD will be used to speed up certain calculations;
The MERGE command has been slightly modified to create conditional expressions. RETURNING support is now available, the expression outputs a value based on changes or deletions made;