PostgreSQL 15

PostgreSQL 15 accelerates data operations with the SQL-standard MERGE command and delivers up to 400 percent faster sorting performance.

PostgreSQL 15 introduces the SQL-standard MERGE command to handle complex conditional logic (INSERT, UPDATE, and DELETE) within a single statement. You get immediate efficiency gains: internal benchmarks show in-memory and on-disk sorting speeds increasing by up to 400 percent. This version expands your compression options by adding Zstandard (zstd) and LZ4 support for Write-Ahead Log (WAL) files, which significantly reduces disk footprint. Security is also prioritized: the new default permissions for the public schema prevent non-owners from creating objects, hardening your environment against unauthorized access.

https://www.postgresql.org/docs/15/release-15.html