This blog post will discuss ways to speed up Cloud SQL migrations for PostgreSQL / AlloyDB workloads
DMS offers continuous migrations from MySQL, PostgreSQL, and SQL Server to Cloud SQL and AlloyDB for PostgreSQL.
PostgreSQL multiple subscriptions move data between source and destination databases in parallel in Google's new DMS
Database Migration Service’s UI and Cloud SQL APIs default to OPTIMAL, which balances performance and source database load
The MAXIMUM setting delivers the fastest speeds, but if the source is already under load, it may slow application performance
Another factor in faster migrations is machine or network configuration. Larger destination and source configurations (RAM, CPU, Disc IO) speed migrations
Before promoting the instance, degrade the machine to a lower tier after migration. This requires a machine restart
Network bandwidth is limited by vCPUs. The network egress cap on write throughput for each VM depends on its type