Amazon RDS for PostgreSQL now supports major version 18

Published

November 14, 2025

Amazon RDS for PostgreSQL

Now supports major version 18, starting with PostgreSQL version 18.1. PostgreSQL 18 introduces several important community updates that improve query performance and database management.

New Features

Skip scan: Support for multicolumn B-tree indexes.
WHERE clause: Improved handling for OR and IN conditions.
Parallel GIN builds: Boosts overall database performance.
UUIDv7: Combines timestamp-based ordering with traditional UUID uniqueness.
Observability: Provides buffer usage counts, index lookup statistics, and per-connection I/O utilization metrics.
Extensions: New pgcollection extension and updates to pgaudit, pgvector, pg_cron, pg_tle, mysql_fdw, and tds_fdw.

Upgrade Options

RDS Blue/Green deployments
Upgrade in-place
Restore from a snapshot

What to do

Learn more about upgrading your database instances in the Amazon RDS User Guide.
Create or update a fully managed Amazon RDS database in the Amazon RDS Management Console.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.