Amazon RDS for PostgreSQL now supports major version 17, starting with PostgreSQL version 17.1. The release 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.4, 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 community updates include support for 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. 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. Learn more about upgrading your database instances in the Amazon RDS User Guide.
Amazon RDS for PostgreSQL makes it simple to set up, operate, and scale PostgreSQL deployments in the cloud. 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.
Source:: Amazon AWS