3 ms·
There are some techniques for mitigating those, such as adding new columns as nullable without a default.
by paulryanrogers 9y ago
There are some techniques for mitigating those, such as adding new columns as nullable without a default.
- idunno246 9y agoRight, adding a column with a default means the alter takes time while holding that lock and nothing can be read/written so is generally unsafe for big tables, but it doesn’t help if the alter can’t acquire the lock in the first place