Excellent breakdown. The missing (id) index lesson is a reminder that fundamentals often matter more than complex optimizations. Also, having a safe rollback strategy made the migration far less risky.
At https://www.remotestate.com/ we see the same principle in scalable system design—move fast, but always make rollback easy.