AWS recently announced that Amazon Aurora, a MySQL and PostgreSQL compatible relational database for the cloud, now supports PostgreSQL major version 12.
PostgreSQL is an open source object relational database system that uses and extends the SQL language. AWS offers a PostgreSQL-compatible database as a fully managed service with Amazon Aurora and now offers support for version 12 after previously supporting smaller versions 11.7, 10.12, and 9.6.17. This new version contains better index management, improved partitioning functions and the execution of JSON path queries according to SQL / JSON specifications. It also enables nondeterministic collations, comparisons between upper and lower case and accent without taking into account collations provided in the ICU, statistics with the most frequent values for improved query plans, the creation of generated columns that calculate values with an expression, and many additional functions support.
The version with support for version 12 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_geocot, Post_gis_tiger_geocot.
In addition to announcing PostgreSQL version 12 support for Amazon Aurora, customers can also upgrade their Amazon Aurora database cluster from major PostgreSQL version 11 to 12 in-place. Customers can upgrade with just a few clicks in the Amazon RDS Management Console or using the AWS SDK or CLI.
AWS also offers Amazon Relational Database Service (RDS), which supports the PostgreSQL database module in addition to MySQL, SQL Server, MariaDB and Oracle. As Ismail Egilmez, Business Development Manager at Thundra, explains in his blog:
Amazon Aurora improves the performance of standard MySQL five times and the performance of standard PostgreSQL two times with the same hardware configuration. In addition, backups are continuous, incremental backups that do not affect database performance. Up to 15 reader replicas are supported, and the failover is fully automatic with no data loss. It also supports the creation of a highly available database cluster with synchronous replication across multiple availability zones.
And finally he writes:
Aurora is generally more expensive than RDS for the same workloads. The price for RDS depends on the type and size of the instance and the EBS volume. Aurora pricing is primarily based on instance size, and storage is billed based on actual usage.
In addition, AWS is not the only cloud provider that offers a managed relational database service that is compatible with PostgreSQL. Microsoft has an Azure database for PostgreSQL and according to documentation supports the community version of PostgreSQL 9.5, 9.6, 10 and 11, while the flexible preview server supports 11 and 12 in the preview. Google also offers a managed relational database service for MySQL, PostgreSQL and SQL Server called Cloud SQL, which supports versions 9.5, 9.6, 10, 11, 12 and 13. Other fully managed databases available as a service in the cloud, such as B. Heroku Postgres, also support version 12.
For more information about Amazon Aurora, see the documentation landing page. Additionally, in-place functionality and support for PostgreSQL version 12 is available in all Aurora PostgreSQL supported regions.