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

episode

The Backend Engineering Show with Hussein Nasser not yet transcribed

▲ 0

Transcript

This episode hasn't been transcribed yet Upvotes decide what gets transcribed next — 0 so far. Sign in to upvote

Related

recent transcribed audio

Trump Makes MAJOR Move as Midterms Get Closer | Guests: Donald & Amy Johnson | 9/29/26 2h 6m · 29 Sep 2026 · The Glenn Beck Program

Best of the Program | Guests: Donald & Amy Johnson | 9/29/26 43 min · 29 Sep 2026 · The Glenn Beck Program

Standoff At Drumcree Enters Third Day 16 min · 29 Sep 2026 · The Last Word with Matt Cooper

The Last Word On Music: Oasis Sell Out Live ’27 Tour In Staggered Three Day Sale 18 min · 29 Sep 2026 · The Last Word with Matt Cooper

The 3 Senate Seats Republicans Can ACTUALLY Flip 1h 2m · 29 Sep 2026 · Next Up with Mark Halperin

Trump Miscalculates as Canada’s PM Carney Plans for US Invasion 16 min · 29 Sep 2026 · Legal AF by MeidasTouch

Report any issue

Source

Recorded04 Feb 2021

Publisheranchor.fm ↗

Handlerec:9885974

Show notes

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/

Ask this episode

“What did the council decide on item 42?” — answered with the speaker and the moment.

Sign in