Posted On: Sep 25, 2018

Amazon Aurora with PostgreSQL Compatibility now supports PostgreSQL major version 10.4, and is available in US East (N. Virginia, Ohio), US West (Oregon), and Europe (Ireland) Regions.

PostgreSQL 10 includes various new features including native table partitioning, support for improved parallelism in query execution, ICU collation support, column group statistics, enhanced postgres_fdw extension, and many more. Additionally, this release includes updated versions of the PLV8, ip4r, and pg_repack extensions.

This release includes all patches from the PostgreSQL 10.1, PostgreSQL 10.2, and PostgreSQL 10.3 minor versions. It also includes all extensions that are supported in the Amazon Aurora with PostgreSQL Compatibility 9.6 release.

To use the new version, you can create an Amazon Aurora with PostgreSQL Compatibility database instance with just a few clicks in the AWS Management Console. You can also create an Amazon Aurora with PostgreSQL Compatibility 10.4 read replica using an RDS for PostgreSQL 10.4 master instance, and then fail over your connections and applications to Aurora when ready. Learn more about migrating to Aurora PostgreSQL 10.4 in the Amazon RDS User Guide.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security.