Posted On: Nov 18, 2024
Amazon Relational Database Service (Amazon RDS) for PostgreSQL now supports major version 17, starting with PostgreSQL version 17.1. This release also includes support for the latest minor versions 16.5, 15.9, 14.14, 13.17, and 12.21. RDS for PostgreSQL comes with support for 94 PostgreSQL extensions such as pgvector 0.8.0, pg_tle 1.4.0, pgactive 2.1.3, and hypopg.1.4.1 that are updated to support PostgreSQL 17. This release also includes support for a new SQL function for monitoring autovacuum, providing insights to prevent transaction ID wraparound.
PostgreSQL 17 includes updates to vacuuming that reduces memory usage, improves time to finish vacuuming, and shows progress of vacuuming indexes. With PostgreSQL 17, you no longer need to drop logical replication slots when performing a major version upgrade. PostgreSQL 17 continues to build on the SQL/JSON standard, adding support for `JSON_TABLE` features that can convert JSON to a standard PostgreSQL table. The `MERGE` command now supports the `RETURNING` clause, letting you further work with modified rows. PostgreSQL 17 also includes general improvements to query performance and adds more flexibility to partition management with the ability to SPLIT/MERGE partitions.
You can upgrade your database using several options including RDS Blue/Green deployments, upgrade in-place, restore from a snapshot, or use Amazon Data Migration Service. Learn more about upgrading your database instances in the Amazon RDS User Guide.
Amazon RDS for PostgreSQL helps make it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Amazon RDS for PostgreSQL is available in Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability. Create or update a fully managed Amazon RDS database in the Amazon RDS Management Console.