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.


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.


2023 Hour Of Code Announced

New activities for this year's Hour of Code have been announced. The focus for 2023,"Creativity with AI", is designed to let students learn about computer science and artificial intelligence.

Grafana Adds New Tools

Grafana Labs has announced new tools to make it easier to analyze application data on Grafana Cloud. The announcements are an Application Observability tool for Grafana Cloud, and Grafana Beyla, the e [ ... ]

More News




or email your comment to: