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


Kotlin 1.7 Unveils New Compiler
16/06/2022

Kotlin 1.7 has been released, with the inclusion of the alpha version of the new Kotlin/JVM K2 compiler. The new release also stabilizes language features, and offers performance improvements for the  [ ... ]



AGE - The Open Source PostgreSQL Extension For Graph Database Functionality
27/06/2022

Apache AGE, "A Graph Extension" was recently announced as an Apache Software Foundation Top-Level Project (TLP). What is the importance of that?


More News

pythondata

 



 

Comments




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