Posted On: Jan 28, 2021

Amazon Aurora with PostgreSQL compatibility now supports major version 12. PostgreSQL 12 includes better index management, improved partitioning capabilities, and the ability to execute JSON path queries per SQL/JSON specifications. It also enables nondeterministic collations that support case-insensitive and accent-insensitive comparisons for ICU provided collations, most common-value statistics for improved query plans, creation of generated columns that compute values with an expression, and many additional features.

This release also updates extensions including Address_standardizer, Address_standardizer_data_us, Amcheck, Citext, Hll, Hstore, Ip4r, Pg_repack, Pg_stat_statements, Pgaudit, Pglogical, Pgrouting, Plv8, Postgis, Postgis_tiger_geocoder, Postgis_topology. You can view a list of all PostgreSQL extensions supported by Aurora PostgreSQL in the AWS User Guide.

To use the new version, create a new Amazon Aurora PostgreSQL database instance with just a few clicks in the Amazon RDS Management Console. You can also use the in-place upgrade functionality to minimize downtime during an upgrade. Please review the Aurora documentation to learn more. PostgreSQL 12 is available in all regions supported by Amazon Aurora PostgreSQL.

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. For more information, please visit the Amazon Aurora product page. To get started with Amazon Aurora PostgreSQL, take a look at our getting started page. Check out this post on the AWS Database Blog to learn more about the new PostgreSQL 12 functionality.