News for hackers. Stuff that matters.
Re:The GitHub Availability Report by Doxin on Thursday July 16, 2020 @02:21AM (#23856345)
More importantly, why is their ID type small enough to where this is even a possibility?
Re:The GitHub Availability Report by hvidgaard on Thursday July 16, 2020 @02:29AM (#23856392)
The "default" is a 32 bit int, large enough for almost 4.3 billion records. That is enough for the vast majority of tables, and going to a 64 bit int has some performance implications, which at GitHubs scale is absolutely something they need to take into consideration, just as they should have with the table size.
Re:The GitHub Availability Report by dx034 on Thursday July 16, 2020 @03:27AM (#23856679)
I've set up systems where I chose 32bit int because I could've never imagined to need more than 4 billion values. AT some points I did (related to deletes) but changing the datatype when you have >1bn records can be next to impossible for 24/7 operations, especially for primary keys.