4 ms·
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,
by idunno246 8y 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