Amazon RDS PostgreSQL 19 Beta 2 Now in Preview Environment
Amazon RDS for PostgreSQL 19 Beta 2 is now available in the RDS Database Preview Environment for evaluation. This pre-release version brings features like parallel autovacuum, native SQL Property Graph Queries, and dynamic logical replication for improved performance and reduced downtime. Beta 2 includes bug fixes and stability enhancements from Beta 1 testing, offering a managed environment for testing PostgreSQL 19's capabilities before general availability.
- →PostgreSQL 19 Beta 2 available in RDS Database Preview Environment
- →Native SQL Property Graph Queries (SQL/PGQ)
- →Parallel autovacuum with configurable worker limits
- →REPACK CONCURRENTLY for online table rebuilding
- →Dynamic logical replication synchronization
Features (2) ›
- PostgreSQL 19 Beta 2 available in RDS Database Preview Environment
Amazon RDS for PostgreSQL 19 Beta 2 is now available for evaluation, allowing users to test PostgreSQL 19 features on a fully managed database service. Instances in the preview environment are retained for a maximum of 60 days and have specific snapshot usage limitations.
- Native SQL Property Graph Queries (SQL/PGQ)
SQL/PGQ enables relationship traversals to be expressed directly within standard SQL, eliminating the need for separate application logic.
Enhancements (3) ›
- Parallel autovacuum with configurable worker limits
PostgreSQL 19 introduces parallel autovacuum with configurable worker limits, designed to prevent routine maintenance from bottlenecking large databases.
- REPACK CONCURRENTLY for online table rebuilding
The new REPACK CONCURRENTLY command allows for online table rebuilding and storage reclamation, ensuring production databases remain accessible without relying on third-party extensions.
- Dynamic logical replication synchronization
Logical replication now automatically synchronizes sequence values and can be enabled dynamically without a server restart, which helps reduce planned downtime.
https://aws.amazon.com/about-aws/whats-new/2026/07/postgresql-19-beta-2-amazon-rds-database-preview-environment/
Related releases
- Amazon RDS/Aurora add Graviton4 R8g instances in more regions, M8g instances wider AWS What's New ·
- RDS and Aurora add R8gd/M8gd instances in more regions AWS What's New ·
- Amazon RDS for Db2 expands to more AWS Commercial regions AWS What's New ·
- Amazon RDS allows up to four storage modifications per day AWS What's New ·
- AWS Config adds 191 managed rules for AI and core services AWS What's New ·
- Amazon RDS for Oracle adds support for Oracle Database 26ai AWS What's New ·