PostgreSQL中serial类型开销及静态数据表主键选型探讨

Summary #

For static reference tables, go with a natural business key if one exists—it’s cleaner and more efficient. If you don’t have a natural key, serial is perfectly acceptable, as its overhead is negligible given the table’s low write activity.

内容的提问来源于stack exchange，提问作者SONewbiee