Faster Heroku Postgres migrations with deferred index rebuilds
We've updated the Heroku Migrator so Heroku Postgres migrations are faster and cover more databases.
The initial copy will now drop secondary indexes on PlanetScale and rebuild them after the data lands. This keeps a single bad index from restarting a multi-hour copy. The tool will also migrate every application schema, not just public, and you can click Verify Migration after switching traffic to compare the two databases.
If you use pg_partman, pause maintenance before you start and resume it on PlanetScale after cutover. Everything else is automated.