The Backend Engineering Show with Hussein Nasser cover image

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

The Backend Engineering Show with Hussein Nasser

00:00

Storing Tables on Disk in a Database

This chapter explores how a database stores tables on disk, discussing the allocation of bytes for each entry, the use of unique identifiers, and the retrieval of multiple rows. It also touches on the differences in storing data on mechanical drives and solid-state drives, including blocks, tracks, sectors, fragmentation, and random access.

Transcript
Play full episode

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app