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


JetBrains Updates Datalore BI Platform
14/06/2022

JetBrains has updated Datalore Enterprise, its data science and BI platform, to add support for Docker-based installation. The Docker support means Datalore can be set up quickly in AWS, GCP, Azure or [ ... ]



TypeScript 4.7 Adds Node.js ECMAScript Module Support
06/06/2022

TypeScript 4.7 has been released with improvements including ECMAScript module support in Node.js, instantiation expressions, and control-flow analysis for computed properties.


More News

pythondata

 



 

Comments




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