PostgreSQL 17 Beta 1 is now available in Amazon RDS Database Preview Environment

The article provides an announcement about the availability of PostgreSQL 17 Beta 1 in the Amazon RDS Database Preview Environment. It highlights some key features and improvements introduced in PostgreSQL 17.

Specifically, the article covers:

• PostgreSQL 17 Beta 1 is now available for evaluation on Amazon RDS Database Preview Environment, allowing users to test the pre-release version in a fully managed database environment.
• New updates in PostgreSQL 17 include improvements to vacuuming that reduce memory usage, faster vacuuming times, and progress tracking for vacuuming indexes.
• Major version upgrades no longer require dropping logical replication slots.
• Enhancements to SQL/JSON support with the addition of JSON_TABLE features for converting JSON to PostgreSQL tables.
• The MERGE command now supports the RETURNING clause for further processing of modified rows.
• General improvements to query performance and added flexibility for partition management with the ability to SPLIT/MERGE partitions.
• Conclusion about the limitations and pricing of the Amazon RDS Database Preview Environment.