After only a three-month gap since its October release, we’re delighted to bring PostgreSQL® 15 to Aiven. The new version comes with a wealth of new capabilities and performance enhancements that make managing workloads in local and distributed environments more efficient, and provide a better developer experience.
Release highlights
Better sort performance and compression
According to the PostgreSQL Global Development Group, PostgreSQL 15’s new algorithms for both in-memory and on-disk sorting result in 25-400% performance improvements. New window functions also enhances performance, as does parallel execution of SELECT DISTINCT queries.
Developer features
The SQL standard MERGE command has been added to PostgreSQL 15, allowing you to to conditionally INSERT, UPDATE or DELETE rows.
You can also now inspect strings with regular expressions including regexp_count(),regexp_instr(), regexp_like(), and regexp_substr().
The aggregation function has been extended to multirange data types.
Other changes
Updated public schema permissions: the PUBLIC schema is no longer writable by default.
In logical replication, PostgreSQL 15 now provides row filtering and column lists for publishers.
You can now set the ICU collation as default for a cluster or an individual database.
Allows unique constraints and indexes to treat NULL values as not distinct
Allows foreign key ON DELETE SET actions to affect only specified columns
To find out more about these and all the other new features, check out the PostgreSQL web page.
To get the latest news about Aiven and our services, plus a bit of extra around all things open source, subscribe to our monthly newsletter! Daily news about Aiven is available on our LinkedIn and Twitter feeds.
If you just want to find out about our service updates, follow our changelog.