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.

postgresqlsqThe 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.

postgresqlsq

More Information

PostgreSQL website

Related Articles

PostgreSQL 14 Is Here - A Look At Its Past And Future

A Deep Dive Into PostgreSQL Indexes

PostgreSQL Is DB-Engines DBMS of the Year For 2020

Aurora Serverless PostgreSQL Generally Available

The Enduring Influence Of Postgres

PostgreSQL Improves Declarative Partitioning 

PostgreSQL Adds Parallel Query Support

PostgreSQL Version 9.5

PostgreSQL 9.4 Released

PostgreSQL Plus Cloud Database

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Banner


Google Rebrands Bard With Subscription
12/02/2024

Google Bard will from now on be known as Gemini, and Google is launching a paid subscription tier that will be based on yet another new AI model from Google. The move to a paid subscription follows th [ ... ]



Android 15 Developer Preview Released
19/02/2024

Android 15 Developer Preview has just been released by the Android team with features including partial screen sharing and the latest version of the Privacy Sandbox.


More News

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info