A Deep Dive in How Slow SELECT * is
The Backend Engineering Show with Hussein Nasser
00:00
Why Select Store Slow?
If you're actually reading the heap, which is the table data, you're right. You have that select store. But here's what you miss on. Let's assume you have an index, like the student. So if I do a query, and assume, let's assume this is my sequel, right? Or sequel server. And I always, I picked those two derivatives because they store secondary indexes a little bit different than Postgres - it's just very similar there here.
Transcript
Play full episode
