UNEXPECTED DOWNSIDES OF UUID KEYS IN POSTGRESQL
UUIDs are commonly used as keys in PostgreSQL databases. However, UUID’s come with their own downsides. The most important of these downsides is a loss of temporal locality. The trouble with picking random values is that they lose any correlation between the order of inserts and the order of IDs. This can lead to a loss of performance.