GUIDE深度 · Deep dive

UUIDs as Primary Keys

UUIDs let clients and services generate IDs without collisions, but random v4 primary keys cause random B-tree inserts; high-write tables may prefer v7 or ULID.

更新 2026-11-01 · 公式可核验

Pros

No centralized sequence.

Easy to merge or migrate across systems.

Does not expose sequential counts.

Costs

16 bytes versus 4 or 8, larger indexes.

Random inserts cause page splits and lower cache hits.

Less readable when debugging.

FAQ

Must I use binary?

Recommended; string UUIDs take 36 bytes and compare slower.

Does it leak user counts?

Random UUIDs do not; auto-increment IDs do.

Sources

Related calculators

UUID GeneratorGenerate UUID v4 in bulk with optional uppercase, locally.

More guides

UUID Versions ExplainedRead guide
KEEP READING

继续读

按顺序读,或跳到同主题的其他指南。

全部指南 →