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.

kyle-buzzell

Kyle Buzzell

|RSS Feed

Head of Growth Marketing at Aiven

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 blogs

  • An invitation to cluster illustration

    Nov 17, 2021

    Aiven invites startups to our new startup program. Find out why Aiven is helping fresh early-stage startups with discounts and other opportunities.

    Auri Poso

    Auri

  • Redis 6 is here illustration

    Nov 4, 2020

    Aiven now offers Redis 6 as a managed service. This post tells you what the key improvements are and how we are bringing it to you. Read on!

    Auri Poso

    Auri

  • Announcing Aiven for OpenSearch® illustration

    Sep 27, 2021

    Aiven is happy to announce the newest arrival on the OpenSearch scene! Read more about Aiven for OpenSearch® and how to upgrade from Elasticsearch.

    Soumya Bijjal

    Soumya

Subscribe to the Aiven newsletter

All things open source, plus our product updates and news in a monthly newsletter.