undefined | Better HN

0 pointspaulryanrogers8y ago0 comments

There are some techniques for mitigating those, such as adding new columns as nullable without a default.

0 comments

1 comments · 1 top-level

Right, 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

j / k navigate · click thread line to collapse