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 doesn’t like 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/

#developer

Write Amplification Explained in Backend Apps, Database Systems and SSDs
3.20 GEEK