Write Amplification Explained in Backend Apps, Database Systems and SSDs

The Backend Engineering Show with Hussein Nasser

English - April 05, 2021 00:16 - 22 minutes - 15.4 MB - ★★★★★ - 5 ratings
Technology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed

Previous Episode: DNS issue impacting multiple Microsoft services on April’s fool day (with Bonus content)

Next Episode: Browser Caching best practices, when to use no-cache vs max-age without breaking your site

Write Amplification Is a phenomenon where the actual writes that physically happen are multiples of the actual writes desired. In this episode, I'll discuss 3 types of write amplifications and their effects on performance and lifetime of storage mediums.

0:00 intro

2:00 Application write amplification

4:30 Database write amplification

9:30 SSD Disk write amplification

16:00 SSD hates BTrees

20:00 summary

Resources

https://en.wikipedia.org/wiki/Write_amplification

https://www.cybertec-postgresql.com/en/hot-updates-in-postgresql-for-better-performance/

https://youtu.be/5Mh3o886qpg