I've got a MySQL database which uses UUID (v4) as identifier for all entities. The UUID's are stored as a
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?