That's a very clarifying explanation of how indexes work, thank you for all the great content. May I ask how does the situation change when you have to add another index (once you have already existing data) to a column? In the context of how does (postgres for example) the db assign new records to pages and how the new index fulfilment value will impact that futureproofness/wasted space tradeoff. I'm a beginner backend developer myself and find so helpful your content, thank you again for diving deep in this architecture/low level topics
I agree, theoretically sequential UUIDs should be compared to integers. They might take more IOs compared to integers though just because of their size (64bit vs however data type UUID uses 128 bit in some cases and more if implemented as a string)
Hes probably one of the few educators you can watch and feel as if its a normal conversation and not some heavy course material. You should try increasing the playback speed
"sometimes databases have feelings. You have to care about the feelings" 🤣
That's a very clarifying explanation of how indexes work, thank you for all the great content.
May I ask how does the situation change when you have to add another index (once you have already existing data) to a column? In the context of how does (postgres for example) the db assign new records to pages and how the new index fulfilment value will impact that futureproofness/wasted space tradeoff.
I'm a beginner backend developer myself and find so helpful your content, thank you again for diving deep in this architecture/low level topics
Great video as always
"Monotokotobotokarati"
- Hussein Nasser, 2022
Great content, funny and informative
Thanks! And big ups for the profile pic, one of my favorite games!
sequential guids are not inferior in the performance to integer values
I agree, theoretically sequential UUIDs should be compared to integers. They might take more IOs compared to integers though just because of their size (64bit vs however data type UUID uses 128 bit in some cases and more if implemented as a string)
That took rubber ducky debugging to a-whole-nother level
Awesome talk man. That disadvantage of reading nulls kind of makes it not worthwhile
My money dont wiggle wiggle LMAO. I hope you are doing well Hussein
MONOTONIC 🤣
monotonically increasing
Bro please don't delay your speech this much it make us feel that we waste most of the time
1.5x speed
Hes probably one of the few educators you can watch and feel as if its a normal conversation and not some heavy course material. You should try increasing the playback speed
I watch his videos at 2x