The Backend Engineering Show with Hussein Nasser

How Does Database Store Tables on Disk? Explained both SSD & HDD

7 snips
May 30, 2020
This podcast explores how databases store tables on disk, discussing the allocation of bytes, unique identifiers, and retrieval of multiple rows. It also compares solid-state drives (SSDs) and hard disk drives (HDDs) in terms of performance and lifespan. The challenges of inserting and updating data in SSDs are addressed, along with the introduction of LSM trees as a solution for rebalancing B-trees on SSDs.
Ask episode
Chapters
Transcript
Episode notes
1
Introduction
00:00 • 2min
2
Storing Tables on Disk in a Database
02:13 • 11min
3
Differences between SSDs and HDDs in storing data
12:54 • 3min
4
Understanding the Challenges of Inserting and Updating Data in SSDs with B-trees
15:35 • 3min
5
Issues with B-trees on SSDs and Introduction to LSM Trees
18:07 • 2min