|PostgreSQL 15 Beta Released
|Written by Kay Ewbank
|Monday, 23 May 2022
The PostgreSQL Global Development Group has made the first beta release of PostgreSQL 15 available for download. Improvements in the new version include support for Merge and more advanced support for JSON.
PostgreSQL is an open source database system that was originally created at the University of California, Berkeley. It is now maintained and developed by the PostgreSQL Global Development Group, a coalition of many companies and individual contributors. PostgreSQL runs on all major operating systems, has been ACID-compliant since 2001, and has add-ons such as the PostGIS geospatial database extender.
The first change to this version is the introduction of the SQL Merge command. In previous releases if you wanted to carry out a Merge you either had to write your own stored procedure or using the Insert...On Conflict, though this was more limited than full Merge.
The new release will also have more extensive support for JSON. There has been basic JSON support since version 9, but the new version makes the support more compliant with the SQL/JSON standard by adding functions to handle SQL/JSON constructors, query / introspection functions, and the ability to convert JSON data into a table.
Another improvement is the inclusion of more regular expression functions including regexp_count , regexp_instr, regexp_like, and regexp_substr. In addition, the range_agg function has been extended to support aggregating multirange types.
PostgreSQL 15 is adding row and column filtering for logical replication, along with the ability to publish all tables in a schema, and better support for handling conflicts when using logical replication.
The developers say that another improvement is to performance, particularly when sorting larger data sets that exceed the work_mem parameter. Query performance has also been improved, with support for running Select Distinct statements using parallelization, and better handling of window functions that use row_number(), rank(), and count().
PostgreSQL 15 beta is available for download now.
or email your comment to: email@example.com