PostgreSQL 19 Beta 3 is now available in Amazon RDS Database Preview Environment
Amazon RDS now offers PostgreSQL 19 Beta 3 in its Database Preview Environment, enabling users to test pre-release features including improved query performance and autovacuum management before general availability.
Amazon Web Services announced the availability of PostgreSQL 19 Beta 3 in the Amazon RDS Database Preview Environment, allowing customers to evaluate the pre-release version on Amazon RDS for PostgreSQL. The update introduces new features focused on query performance and autovacuum management, including the pg_stat_autovacuum_scores view for monitoring and tuning prioritization. Parallel autovacuum support enables multiple workers to accelerate maintenance on large tables, while the pg_plan_advice module helps maintain efficient query plans to prevent unexpected slowdowns.
The Beta 3 release also includes eager aggregation, which improves analytical query performance by grouping data earlier to reduce processing rows and speed up completion. Additional enhancements address bug fixes and stability improvements derived from Beta 2 testing. Users are advised to consult the PostgreSQL community announcement for further technical details on the new features and changes.
Amazon RDS Database Preview Environment instances hosting PostgreSQL 19 Beta 3 are retained for a maximum of 60 days and are automatically deleted afterward. Snapshots created in this environment can only be used to restore instances within the same Preview Environment, ensuring isolation from production environments.
Pricing for PostgreSQL 19 Beta 3 instances in the Amazon RDS Database Preview Environment follows the standard rates for the US East (Ohio) Region. Users can import or export databases using PostgreSQL dump and load functionality, facilitating data migration between the Preview Environment and other PostgreSQL deployments.