PostgreSQL 11 is Now Available in Amazon RDS Database Preview Environment

Posted on: Oct 25, 2018

PostgreSQL 11 is now available in the Amazon RDS Database Preview Environment, allowing customers to test the early production version of PostgreSQL 11 on Amazon RDS including 40+ extensions like PostGIS and support for hash partitioning. PostgreSQL 11 can now be deployed for development and performance testing in the Amazon RDS Database Preview Environment without the hassle of installing, provisioning, and managing the database.

The PostgreSQL community released PostgreSQL 11 on October 18, 2018. PostgreSQL 11 provides users with improvements to overall performance of the database system, particularly for very large databases and high computational workloads. Further, PostgreSQL 11 makes significant improvements to the table partitioning system, adds support for stored procedures capable of transaction management, improves query parallelism, adds parallelized data definition capabilities, and introduces just-in-time (JIT) compilation for accelerating the execution of expressions in queries.

Amazon RDS Database Preview Environment database instances are priced the same as production RDS instances created in the US East (Ohio) Region. The RDS Database Preview Environment supports both Single-AZ and Multi-AZ deployments on the latest generation of instance classes (currently T2, M4, and R4), and can be encrypted at rest using KMS keys. Database instances are retained for a maximum period of 60 days and are automatically deleted after the retention period. To move data in and out of the preview environment, customers can either use standard PostgreSQL dump and load functionality or use native PostgreSQL logical replication.

The Amazon RDS Database Preview Environment Forum is available for customers and the Amazon RDS team to share information and concerns about both the early production versions of PostgreSQL 11 and the RDS Database Preview Environment. For details on Amazon RDS Database Preview Environment, refer to https://aws.amazon.com/rds/databasepreview.