logo
episode-header-image
May 2020
18m 55s

How Does Database Store Tables on Disk? ...

Hussein Nasser
About this episode

in this video I explain how database systems store their data on Disk both f from SSD (solid-state drives) and HDD (HarD disk drive).   There are many factors that go into that discussion so I tried to cover the high level here.   Reseources https://www.extremetech.com/extreme/210492-extremetech-explains-how-do-ssds-work https://www.percona.com/blog/2019/12/18/give-love-to-your-ssds-reduce-innodb_io_capacity_max/

--- Support this podcast: https://anchor.fm/hnasr/support
Up next
Jun 13
kTLS - Kernel level TLS
Fundamentals of Operating Systems Course https://oscourse.winktls is brilliant.TLS encryption/decryption often happens in userland. While TCP lives in the kernel. With ktls, userland can hand the keys to the kernel and the kernel does crypto. When calling write, the kernel encryp ... Show More
22m 55s
May 9
The beauty of the CPU
If you are bored of contemporary topics of AI and need a breather, I invite you to join me to explore a mundane, fundamental and earthy topic.The CPU.A reading of my substack article https://hnasr.substack.com/p/the-beauty-of-the-cpu 
9m 38s
Apr 18
Sequential Scans in Postgres just got faster
This new PostgreSQL 17 feature is game changer. They know can combine IOs when performing sequential scan. Grab my database coursehttps://courses.husseinnasser.com 
27m 36s
Recommended Episodes
Aug 2020
Hard Disk Drives vs Solid State Drives
When it comes to long-term data storage on computers, there are two main camps. In this episode, we learn how hard disk drives are different from solid state drives. Learn more about your ad-choices at https://www.iheartpodcastnetwork.comSee omnystudio.com/listener for privacy in ... Show More
49m 23s
Jun 2024
Seagate Helps Tame the Cloud’s Exabyte Demand
Seagate’s relentless hard-disk-drive technology innovation has expanded mass-capacity storage solutions over the past several years. Jason Feist, senior vice president of products and markets, sits down with Woo Jin Ho, Bloomberg Intelligence hardware and networking analyst, in t ... Show More
41m 53s
Mar 2024
Hard Disk Drive
In this episode of the I Can't Sleep Podcast, fall asleep learning about Hard Disk Drives. I'm not going to try and come up with something interesting for this one because it was a bore to read. Happy sleeping! Ad-Free EpisodesWant an ad-free experience? Follow this link to suppo ... Show More
47m 47s
Oct 2023
Things Legacy Storage Made You Worry About (That You Shouldn't Have To)
Ever wondered about the origin of certain storage or IT administrative tasks? Because of legacy architectures, IT practitioners have been forced to worry about and repeatedly carry out certain administrative tasks because, well, "that's how it's always been with this product." Jo ... Show More
54m 56s
Sep 2023
Unplugged Volume 14: Metadata - the Secret Sauce, Events and Disk Retirement webinar recap
The intrepid Unplugged crew returns for an exciting Volume 14 where Andrew Miller, JD Wallace and I take on another of Pure's architectural decisions - this time we dig deep into the use of Metadata in the software stack. The extensive use of Metadata enables FlashArray to delive ... Show More
48m 50s
Feb 2020
Data Modeling That Evolves With Your Business Using Data Vault
Summary Designing the structure for your data warehouse is a complex and challenging process. As businesses deal with a growing number of sources and types of information that they need to integrate, they need a data modeling strategy that provides them with flexibility and speed ... Show More
1h 6m
Apr 2024
Des cartes SD bientôt de 4 To de stockage ?
C’est dans un communiqué diffusé mi-avril que Western Digital, le spécialiste des cartes SD et des disques durs, a évoqué l'arrivée prochaine de cartes SD de 4 To. Jusqu’à présent, seules des cartes de 1 To étaient disponibles dans la gamme SanDisk Extreme Pro. Mais en quadruplan ... Show More
1m 48s