Posted On: Dec 19, 2018
Amazon Aurora with PostgreSQL Compatibility now supports PostgreSQL major version 10.5, and is available in the US East (N. Virginia, Ohio), US West (Oregon), Europe (Ireland), Asia Pacific (Tokyo), and Asia Pacific (Seoul) Regions.
Amazon Aurora with PostgreSQL Compatibility version 10.5 adds support for Query Plan Management, a new feature that allows you to control how and when query execution plans change. Query plan management allows you to prevent plan regressions when the database system or environment changes, and allows you to control when and whether the optimizer can use new plans.
This release includes all patches from the PostgreSQL 10.1, PostgreSQL 10.2, PostgreSQL 10.3, PostgreSQL 10.4, and PostgreSQL 10.5 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.5 read replica using an RDS for PostgreSQL 10.5 master instance, and then fail over your connections and applications to Aurora when ready. Learn more about migrating to Aurora PostgreSQL 10.5 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.