Skip to content
UUIDs are Bad for Performance in MySQL - Does Postgres Win? Let us Discuss episode artwork

Feb 4, 2021 21 min

UUIDs are Bad for Performance in MySQL - Does Postgres Win? Let us Discuss

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

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/

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

UUIDs are Bad for Performance in MySQL - Does Postgres Win? Let us Discuss

0:00 21:00

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 21 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on February 4, 2021.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.