Posted On: Jan 27, 2022
HAQM Relational Database Service (HAQM RDS) for PostgreSQL and HAQM RDS on AWS Outposts now support PostgreSQL major version 14. PostgreSQL 14 includes performance improvements for parallel queries, heavily-concurrent workloads, partitioned tables, logical replication, and vacuuming. PostgreSQL 14 also improves functionality with new capabilities. For example, you can cancel long-running queries if a client disconnects and you can close idle sessions if they time out. In addition, stored procedures now return data.
HAQM RDS for PostgreSQL supports over 80 extensions and loadable modules including PostGIS 3.1 for geospatial data, pg_cron for scheduling database jobs, and data import and export with HAQM S3. HAQM RDS for PostgreSQL supports the latest Graviton2 instances including T4g for bursty workloads and X2g for memory-intensive workloads. You can upgrade your database using several options including upgrade in-place, restore from a snapshot, replicate with the pglogical extension, or use AWS Data Migration Service.
HAQM RDS makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. See HAQM RDS for PostgreSQL Pricing and HAQM RDS on AWS Outposts Pricing for pricing details. Create or update an HAQM RDS for PostgreSQL database instance with just a few clicks in the AWS Management Console.