PostgreSQL 18.0 is now available in Amazon RDS Database Preview Environment

Amazon RDS for PostgreSQL 18.0 Preview

Amazon RDS for PostgreSQL 18.0 is now available in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest PostgreSQL features while leveraging the benefits of a fully managed database service. This preview environment provides a sandbox where you can test applications and explore new PostgreSQL 18.0 capabilities before they become generally available.

New Features

• Skip Scan: Support for multicolumn B-tree indexes.
• WHERE Clause Handling: Improvements for OR and IN conditions.
• Parallel GIN Builds: Updates join operations.
• UUIDv7 Support: Combines timestamp-based ordering with traditional UUID uniqueness.
• Observability Improvements: Show buffer usage counts, index lookups, and per-connection I/O utilization.

Limits and Quotas

• Instance Retention: Maximum period of 60 days.
• Snapshot Usage: Can only be used within the preview environment.

What to do

• Use PostgreSQL dump and load functionality to import or export your databases from the preview environment.
• Refer to the RDS PostgreSQL release documentation for more details.

Source: AWS release notes