db nugget: uuids bloat indexes.
companies that operate at scale often avoid them for transactional use cases.
moreover, uuids cause inserts to occur in random order, leading to index fragmentation and frequent b-tree rebalancing, which results in higher write latencies.