« if you only require 16 bits integer width, there's not much point in picking a 32 bit integer type »
A C hacker (author of lighttpd) taught me ~20 years ago that you'd always choose the native register size for database indices that would be involved in JOINs even when you'd never expect to have so many records, because that's what the machine performs best on.