On Tuesday, August 25, 2015, Melvin Davidson <melvin6...@gmail.com> wrote: > > Before ANYONE continues to insist that a serial id column is good, > consider the case where the number of tuples will exceed a bigint. > Don't say it cannot happen, because it can. > However, if you have an alphanumeric field, let's say varchar 50, and it's > guaranteed that it will never have a duplicate, then THAT is a natural > primary > key and beats the hell out of a generic "id" field. >
Except for it being fatter. 400 bits wide instead of 64. But that, too, is simply another consideration to evaluate. David J.
