PostgreSQL 15 released: Top things to know

PostgreSQL 15 has been released, introducing several new features and improvements. One of the key additions is the SQL MERGE command, which combines INSERT, UPDATE, and DELETE operations into a single statement. This feature provides more capabilities than the existing INSERT ON CONFLICT feature in Postgres. Additionally, CREATE permission has been revoked for the public schema to enhance security. Structured JSON Logging is now supported, allowing for convenient exporting of logs and integration with monitoring tools like HoneyComb and DataDog. Performance improvements have also been made, particularly in sorting algorithms. The latest version can be tested locally using Docker Compose.