Tech

The first beta version of PostgreSQL 15 is now available

The team at PostgreSQL, a data warehouse for web, mobile, geospatial, and analytics applications, today announced that the first beta release of PostgreSQL 15 is now available for download.

Beta provides users with a preview of all the features that are set to be available when PostgreSQL 15 is generally available. Information on these features and changes Release notes..

According to the company, this release offers several new features to simplify and enhance the developer experience. These features include mergeA standard SQL command for conditionally performing write operations on data.

Prior to this release, you could do the same thing using stored procedures or using “INSERT… ON CONFLICT”. Developers can now write simple queries to select the correct data modification action.

PostgreSQL 15 is adding standards based on existing support for the SQL / JSON path language. SQL / JSON function..Included in these SQL / JSON constructor, Query / introspection function,and Convert JSON data to a table..

In addition, the beta release adds regular expression functions such as regexp_count, regexp_like, and regexp_substr. The range_agg function was also introduced in PostgreSQL 15 to support multirange type aggregation.

This release also provides significant speedups when sorting data when sorting larger datasets.

The performance improvements included in PostgreSQL 15 extend to a variety of query types, including the introduction of parallelization. Select a distance Statement and performance improvements Window function Use “row_number ()”, “rank ()”, and “count ()”.

The company strongly encourages interested users to test these new features on their systems and provide feedback to eliminate possible bugs and issues. For more information, Website..

The first beta version of PostgreSQL 15 is now available

Source link The first beta version of PostgreSQL 15 is now available

Show More

Related Articles

Back to top button