Posted On: Mar 31, 2020

Amazon RDS for PostgreSQL now supports major version 12. PostgreSQL 12 includes better management of indexing, improved partitioning capabilities, JSON path queries per SQL/JSON specifications, 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 computes values with an expression, and many additional features. 

This release updates extensions including PostGIS to version 3.0, PGAudit to version 1.4, wal2json to version 2.1, PLV8 to version 2.3.14, Orafce to version 3.8, pg_repack to version 1.4.5, pg_hint_plan to version, and pglogical to version 2.3.0.

To use the new version, you can create a new Amazon RDS for PostgreSQL database instance with just a few clicks in the AWS Management Console

Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability. Learn more about the new functionality of PostgreSQL 12 in the AWS Database Blog.