A Deep Dive in How Slow SELECT * is
The Backend Engineering Show with Hussein Nasser
00:00
How to Read Raw Bytes From an SSD Drive
We deal mostly with block storage. So everything is a block. If you want to read a single byte, you read whatever the number of minimum number of blocks the file system allows you to. And that's 4k in most cases. The database now takes those place those those memory location and space them into something called the shared buffers,. It's the databases on cache where those pages will be lived so that hopefully someone will want to query something that is in the same page.
Transcript
Play full episode
