Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I was talking about the way to do it before. You could create a NULL-able column, add the default in batches, add the default/make it non-NULL-able. But, the last part took some time (not in the range of ms) for large tables.


> But, the last part took some time (not in the range of ms) for large tables

create a temporary index covering that column. Then it will be in the range of ms.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: