amazon-rds

On 2026-07-16 AWS put PostgreSQL 19 Beta 2 in RDS Preview. Our first-party REPACK CONCURRENTLY run cut an 873 MB bloated table to 429 MB in 4.5s with 60/60 concurrent SELECTs succeeding.

For an on-prem MySQL estate (~1.1 TB, 340 tables), DMS full load + CDC into Aurora MySQL cut planned downtime from 6h → 18 min — LOB misconfiguration added 11 hours of rework before cutover.

July 2026 field note: Aurora failover windows still force app timeouts above tens of seconds; DynamoDB hot partitions and short transactions remain the scaling levers — with a partition-math worksheet you can reproduce.