Aiven brings PostgreSQL® version 15 to your data infrastructure. Find out what the key improvements are and how you can get the new version.
Serhat Yanikoglu
|RSS FeedProduct Manager
Subscribe for the latest news and insights on open source, Aiven offerings, and more.
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.
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.
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.
ON DELETE SET actions to affect only specified columnsTo find out more about these and all the other new features, check out the PostgreSQL web page.
Upgrade to PostgreSQL 15 to take advantage of these features. If you already use Aiven for PostgreSQL, you can run an in-place upgrade to migrate to the newest version.
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.