I've got a MySQL database which uses UUID (v4) as identifier for all entities. The UUID's are stored as a CHAR(36)
and ascii
charset.
For one table with about 50.000.000 rows, the index on the UUID columns takes up about 5.5GB.
It is my understanding that Postgres handles UUID's better (performance wise) than MySQL / InnoDB because of the builtin uuid
data type in Postgres.
Does Postgres store UUIDs in a more optimized way than MySQL, and should I expect the UUID index to take up less space than it does in MySQL / InnoDB?