undefined | Better HN

0 pointspaulryanrogers7y ago0 comments

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

0 comments

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

0 pointspaulryanrogers7y ago0 comments

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

0 comments

idunno2467y ago

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