Hacker News new | ask | show | jobs
by devmach 4056 days ago
If I'm not mistaken: Altering a table can be costly and may cause a performance issues, specially if you have millions of records. Rows will be most likely locked and get updated and during this process other threads should wait until related row become "free".
1 comments

That only happens if you add a non-nullable column.