Nov 5, 2018
PostgreSQL® 11 now generally available on Aiven
PostgreSQL 11 is now available on the Aiven platform. Read our latest post to find out what changes have been made to PG 11.
Last October, we were the first to offer PostgreSQL 10 for production environments. This November, we are proud to announce that our users are the first to gain access to PostgreSQL 11.
As with all major releases, PostgreSQL 11 includes bug fixes and is full of performance changes; but, if there were a theme to this latest release, it would center around improved handling of large-scale data.
In this post, we’ll take a look at some of the more noteworthy improvements around partitioning and queries, and how they make Postgres even more powerful for use cases with large data sets.
Noteworthy updates to PostgreSQL 11
1. Improved partitioning
Partition elimination has been greatly enhanced, providing even quicker access to tables with multiple partitions and opening it up to query execution. Additionally, some tasks are now automated, such as updated rows moving to new partitions based on the row contents.
2. Parallel queries
PostgreSQL 11 comes with many improvements to parallelization, including what can be parallelized and parallel worker configuration. For example, you can now build btree indexes in parallel and parallelize certain queries.
3. Just-in-Time compilation
A powerful way to increase the execution speed through making some expressions into natively executed functions by the CPU, Just-in-Time compilation has been expanded to include support for additional SQL code and parts of query plans.
Wrapping up
PostgreSQL 11 continues to improve PG’s scalability by improving partitioning and parallel queries, and expanding Just-in-Time compilation. These improvements will result in greater speed and resource management.
Coupled with Aiven features like local SSDs, Aiven users will get even greater performance from PostgreSQL 11. If you’re an Aiven user, get the latest version by simply performing an in-place upgrade within the console. Not an Aiven user?
Take our PostgreSQL as a Service for a complimentary, no-commitment spin. In the meantime, subscribe to our changelog and blog RSS feeds, and follow us on Linkedin and Twitter to stay current with the latest news. Talk soon!
* For a complete breakdown of PostgreSQL 11 improvements, check out their release notes.
Related resources
Oct 19, 2021
Aiven extended its Series C to $160 million, reaching unicorn status. Find out what it means for Aiven and for the future of open source data technologies.
May 20, 2021
Learn to use pgAdmin with PostgreSQL by... watching movies? Find out more!
Aug 11, 2022
PostgreSQL extensions provide great functionality for users, but they are difficult to provide securely. Aiven has an open source solution to this problem!