JA EN
shiichan

PostgreSQL 19 Beta 2 lands in the RDS preview environment — try parallel autovacuum and online REPACK!

AWS What's New ★★★★ View Markdown
#aws#infrastructure

Hi, it's Shiichan! Today's news lets you get an early look at the next major version of PostgreSQL.

AWS What's New aws.amazon.com

What was announced?

According to AWS's What's New, PostgreSQL 19 Beta 2 is now available in the Amazon RDS Database Preview Environment, letting you evaluate this pre-release version of PostgreSQL 19 while still getting the benefits of a fully managed RDS instance.

The story so far

With previous versions of PostgreSQL, autovacuum ran single-threaded and could become a bottleneck on large databases. Rebuilding tables and reclaiming storage often required third-party extensions. Exploring graph-like relationships in your data meant writing separate application logic, since standard SQL alone couldn't express it. And logical replication didn't automatically sync sequence values, sometimes requiring a server restart just to enable it.

What changes

PostgreSQL 19 addresses these pain points together. Parallel autovacuum with configurable worker limits means routine maintenance is less likely to bottleneck large databases. The new REPACK CONCURRENTLY command rebuilds tables and reclaims storage online, so you can skip third-party extensions and keep production databases running. Native SQL Property Graph Queries (SQL/PGQ) let you traverse relationships directly in standard SQL, without separate application logic. Logical replication can now sync sequence values automatically and be enabled dynamically without a server restart.

Dive Deep

Beta 2 includes bug fixes and stability improvements found during the Beta 1 testing period, with refinements to parallel autovacuum worker coordination and REPACK CONCURRENTLY lock handling.

Keep in mind that Amazon RDS Database Preview Environment instances are retained for a maximum of 60 days and are automatically deleted afterward, so treat this as an environment for evaluation, not production. Snapshots created in the preview environment can only be restored within the preview environment, so you'll need a separate dump-and-load approach if you want to move data elsewhere. For more details, check the PostgreSQL community announcement and the RDS Database Preview Environment documentation.

Wrap-up

  • PostgreSQL 19 Beta 2 is now available in the Amazon RDS Database Preview Environment
  • Parallel autovacuum with configurable worker limits reduces maintenance bottlenecks on large databases
  • REPACK CONCURRENTLY rebuilds tables and reclaims storage online
  • Native SQL/PGQ adds graph traversal directly in standard SQL
  • Logical replication now syncs sequence values automatically and can be enabled dynamically without a restart
  • Preview environment instances are automatically deleted after a maximum of 60 days

Great news for database engineers who want a head start on PostgreSQL's next major version!

Related posts