PostgreSQL 15 (postgresql.org)

Article summary

The PostgreSQL Global Development Group has released PostgreSQL 15, the latest version of the open-source database. This release improves performance, particularly in sorting and compression, and adds new features such as the SQL standard MERGE command and support for regular expressions. The update also enhances security and logging capabilities. Additionally, PostgreSQL 15 introduces a new logging format called jsonlog, which allows for structured logging and easier processing of log data.

Main themes

• PostgreSQL 15 release
• MERGE command
• performance improvements
• security enhancements
• logging and monitoring
• open-source contributions
• database performance optimization

What commenters say

• The MERGE command is a valuable addition to PostgreSQL, but it may introduce complexity and concurrency issues, similar to its implementation in MS SQL.
• Some users prefer the existing INSERT ... ON CONFLICT syntax over MERGE, citing its simplicity and explicitness.
• The performance improvements in PostgreSQL 15, such as faster sorting and parallel execution of SELECT DISTINCT queries, will have a significant impact on real-world workloads.
• The new jsonlog format will make it easier to process and analyze log data, improving debugging and monitoring capabilities.
• The revocation of CREATE permissions for the public schema is a step towards improving security in PostgreSQL.
• Microsoft's contributions to open-source projects like PostgreSQL are notable, but it's also important to recognize the contributions of other companies and individuals.
• The implementation of parallel distinct queries in PostgreSQL 15 is likely to be based on a simple merge of datasets, rather than a shared data structure.