News for hackers. Stuff that matters.
Re:GitHub's online schema migration for MySQL by daigoba66 on Thursday May 03, 2018 @04:55AM (#16984370)
That’s not always the best advice.

Consider a table that you know will only have a few rows, but is referenced in one or more FK columns. If I use a 64bit integer when 32bit (or smaller!) is enough, I’m now using twice as much space for the FK column. If there are millions of rows, plus indexes, that can add up pretty fast.

There are no comments on this comment yet.