Skip to main content

PostgreSQL releases PostgreSQL 15

The team behind the open-source database PostgreSQL today announced the release of PostgreSQL 15.

According to the project maintainers, this release builds on the performance improvements of recent releases with gains for managing workloads in both local and distributed deployments, including improved sorting.

PostgreSQL 15 is intended to improve the overall developer experience with the addition of the MERGE command for writing conditional SQL statements that can include INSERT, UPDATE, and DELETE actions within one statement as well as several capabilities for observing the state of the database.

“The PostgreSQL developer community continues to build features that simplify running high performance data workloads while improving the developer experience,” said Jonathan Katz, a PostgreSQL core team member. “PostgreSQL 15 highlights how, through open software development, we can deliver to our users a database that is great for application development and safe for their critical data.”

This latest release improves on PostgreSQL’s in-memory and on-disk sorting algorithms, with benchmarks showing speedups of 25% – 400% depending on which data types are sorted.

Additionally, Using row_number(), rank(), dense_rank(), and count() as window functions also bring performance benefits in PostgreSQL 15.

This release also provides heightened flexibility for managing logical replication with row filtering and column lists. These features allow users to choose to replicate a subset of data from a table.

It also introduces a new logging format: jsonlog which outputs log data using a defined JSON structure, allowing PostgreSQL logs to be processed in structured logging systems.

To read the full list of updates, click here.

The post PostgreSQL releases PostgreSQL 15 appeared first on SD Times.



from SD Times https://ift.tt/NuX70Wj
Labels:

Comments

Post a Comment

Popular posts from this blog

A guide to data integration tools

CData Software is a leader in data access and connectivity solutions. It specializes in the development of data drivers and data access technologies for real-time access to online or on-premise applications, databases and web APIs. The company is focused on bringing data connectivity capabilities natively into tools organizations already use. It also features ETL/ELT solutions, enterprise connectors, and data visualization. Matillion ’s data transformation software empowers customers to extract data from a wide number of sources, load it into their chosen cloud data warehouse (CDW) and transform that data from its siloed source state, into analytics-ready insights – prepared for advanced analytics, machine learning, and artificial intelligence use cases. Only Matillion is purpose-built for Snowflake, Amazon Redshift, Google BigQuery, and Microsoft Azure, enabling businesses to achieve new levels of simplicity, speed, scale, and savings. Trusted by companies of all sizes to meet...
1 comment
Read more

Olive and NTT DATA Join Forces to Accelerate the Global Development and Deployment of AI Solutions

U.S.A., March 14, 2021 — Olive , the automation company creating the Internet of Healthcare, today announced an alliance with NTT DATA , a global digital business and IT services leader. The collaboration will fast track the creation of new healthcare solutions to transform the health experience for humans — both in the traditional healthcare setting and at home. As a member of Olive’s Deploy, Develop and Distribute Partnership Programs , NTT DATA is leveraging Olive’s open platform to innovate, build and distribute solutions to Olive’s customers, which include some of the country’s largest health providers. Olive and NTT DATA will co-develop new Loops — applications that work on Olive’s platform to provide humans real-time intelligence — and new machine learning and robotic process automation (RPA) models. NTT DATA and Olive will devote an early focus to enabling efficiencies in supply chain and IT, with other disciplines to follow. “This is an exciting period of growth at Olive, so...
Post a Comment
Read more

2022: The year of hybrid work

Remote work was once considered a luxury to many, but in 2020, it became a necessity for a large portion of the workforce, as the scary and unknown COVID-19 virus sickened and even took the lives of so many people around the world.  Some workers were able to thrive in a remote setting, while others felt isolated and struggled to keep up a balance between their work and home lives. Last year saw the availability of life-saving vaccines, so companies were able to start having the conversation about what to do next. Should they keep everyone remote? Should they go back to working in the office full time? Or should they do something in between? Enter hybrid work, which offers a mix of the two. A Fall 2021 study conducted by Google revealed that over 75% of survey respondents expect hybrid work to become a standard practice within their organization within the next three years.  Thus, two years after the world abruptly shifted to widespread adoption of remote work, we are dec...
Post a Comment
Read more