Amazon Aurora PostgreSQL adds support for version 18.3
Amazon Aurora PostgreSQL now supports PostgreSQL major version 18.3, bringing community improvements for query performance, database management, and new capabilities like pg_roaringbitmap for efficient set operations. This update benefits users by improving query execution, reducing index overhead, and enabling faster logical replication. The feature is available in all commercial AWS Regions and AWS GovCloud (US) Regions, with multiple upgrade paths available.
- →Support for PostgreSQL 18.3 major version
- →Optimizer statistics retained after major version upgrades
- →Parallel streaming of large transactions for logical replication
- →Availability and upgrade options
Features (1) ›
- Support for PostgreSQL 18.3 major version
Amazon Aurora PostgreSQL-Compatible Edition now supports major version 18.3. This release includes community improvements to query performance and database management, along with new extensions like pg_roaringbitmap for efficient integer set operations. It also introduces B-tree skip scans for improved query performance and reduced index overhead.
Enhancements (2) ›
- Optimizer statistics retained after major version upgrades
Major version upgrades to PostgreSQL 18 now retain optimizer statistics. This ensures consistent query performance immediately after an upgrade, eliminating the need to wait for statistics to regenerate.
- Parallel streaming of large transactions for logical replication
Logical replication can now stream large transactions in parallel. This reduces replication lag and helps keep downstream systems more up-to-date.
Notes (1) ›
- Availability and upgrade options
Aurora PostgreSQL 18.3 is available in all commercial AWS Regions and AWS GovCloud (US) Regions. Users can upgrade using RDS Blue/Green deployments, in-place upgrades, or by restoring from a snapshot.
https://aws.amazon.com/about-aws/whats-new/2026/06/amazon-aurora-postgresql-major-version-18/