Basecamp 因为使用 int 主键,单表达到上限 21 亿之后,服务变成只读模式近 5 小时。
Just in case you were curious to know how long it takes to upgrade a 200GB table with 2,147,483,647 rows in it from int to bigint. The answer is 2:52 hours on extremely beefy hardware
Basecamp 3 is fully back after nearly five hours of being stuck in read-only mode. We're so sorry for what happened today. The play-by-play of our trials and our explanation for what happened is available on SvN:https://m.signalvnoise.com/update-on-basecamp-3-being-stuck-in-read-only-as-of-nov-8-9-22am-cst-c41df1a58352
看了一圈评论,发现一些有意思的点:
postgres 在线修改数据类型: https://github.com/digoal/blog/blob/master/201811/20181108_01.md