Oct 11, 2025 · Databases

Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification

Uber migrated its core database from PostgreSQL to MySQL because PostgreSQL suffered from index bloat, write amplification, high replication overhead, and limited MVCC support, prompting a detailed analysis of each issue, the improvements in newer PostgreSQL releases, and how MySQL’s architecture addresses these challenges.

Index BloatPostgreSQLReplication

0 likes · 12 min read

Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification

dbaplus Community

Aug 6, 2023 · Databases

Why UUIDs Can Hurt PostgreSQL Performance and When to Use Them

This article examines the drawbacks of using UUIDs as primary keys in PostgreSQL—highlighting WAL and index bloat, performance penalties, benchmark comparisons with sequences, and suggests ordered UUID alternatives for better scalability and maintainability.

Index BloatPostgreSQLSequential UUID

0 likes · 9 min read

Why UUIDs Can Hurt PostgreSQL Performance and When to Use Them