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 Amazon Web Services 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, including in Amazon Web Services China (Beijing) region, operated by Sinnet, and Amazon Web Services China (Ningxia) region, operated by NWCD.