3 ms·
That's very true. Sometimes you can't do a live migration and you have to bite the bullet.
by bitops 14y ago
That's very true. Sometimes you can't do a live migration and you have to bite the bullet.
- jeltz 14y agoWhich means it is not too much unlike a quality RDBMS like PostgreSQL. For adding (remember to not set a default value for large tables) and removing fields in PostgreSQL there is no requirement for locking the tables more than an instant. But for complicated schema changes you may have to either force a long lock or use some messy plan either involving replication or doing the migration in multiple steps.