Amazon RDS for PostgreSQL now supports major version 18

This article announces that Amazon RDS for PostgreSQL now supports major version 18, starting with PostgreSQL 18.1, bringing significant performance and management improvements.

• Skip scan support for multicolumn B-tree indexes improves query optimization
• Enhanced WHERE clause handling for OR and IN conditions boosts performance
• Parallel GIN builds and updated join operations enhance database performance
• UUIDv7 combines timestamp ordering with UUID uniqueness for distributed systems
• Improved observability with buffer usage counts and per-connection I/O metrics
• Support for pgcollection extension and updates to pgaudit, pgvector, pg_cron, and others
• Multiple upgrade options available: Blue/Green deployments, in-place, or snapshot restore

PostgreSQL 18 on RDS delivers performance improvements and better observability for cloud-based PostgreSQL deployments.