UUIDs are Bad for Performance in MySQL - Does Postgres Win? Let us Discuss
The Backend Engineering Show with Hussein Nasser - A podcast by Hussein Nasser
Categories:
MySQL is clustered by default on the primary key which means inserts have to be ordered, let us discuss why UUID (random in nature) has bad performance in MySQL and whether postgres wins here. We will also explain why Sequential Writes are Faster than Random in MYSQL and https://www.percona.com/blog/2019/11/22/uuids-are-popular-but-bad-for-performance-lets-discuss/
