Beautifully explained man, one thing that I got to wonder is that does AWS Redshift leverage users' querying patterns to recluster the tables to optimize performance. seems like the only way to do so based on your explanation.
Great video as usual. I had couple of questions. As you have mentioned that we can have a clustering index on the grade column, which I am assuming is not unique, does this affect when we are inserting the data in the table or do databases have a mechanism to create each entry in the grade column as unique, something which SQL Server does. And is it best practice to have Clustered index on a unique and non-null column or it depends upon the queries the user is going to use?
Every one showing mysql clustering on youtube(percona xtradb ,galera,group replication,etc). But i want to do simple write and read replicas and also integrate with demo with frontend+backend app!. Load balance with all them . Can some one show me the demo.Oh i am frustrated.!!!! Please give me proper guide someone...
You cluster your data in a table and then Postgre will keep appending inserts?! What the... I thought that the reason behind the clustering was to have data ordered based on some index and KEEP IT that way... I would be ok if they offered a "Append inserts" functionality as a optional behaviour after clustering if you are ok with re-clusteding data once in a while but to do it by default?! If this is the case then what was the point of clustering when you cannot keep it/
Check out my udemy Introduction to Database Engineering course husseinnasser.com/courses Learn the fundamentals of database systems to understand and build performant backend apps
Hurray for backend show! Lol its 2:13 AM where I am and I'm managing my new aws servers rollout in the terminal. Great timing!
Perfectly explained Hussein! Thanks a lot. I really want to work people like you who I can converse with on multitude of topics.
Beautifully explained man, one thing that I got to wonder is that does AWS Redshift leverage users' querying patterns to recluster the tables to optimize performance. seems like the only way to do so based on your explanation.
Love the hair! Awesome content as usual
Thanks !
6:44 there is no link to B tree video
You make backend engineering feel like philosophy.
Great video as usual. I had couple of questions. As you have mentioned that we can have a clustering index on the grade column, which I am assuming is not unique, does this affect when we are inserting the data in the table or do databases have a mechanism to create each entry in the grade column as unique, something which SQL Server does. And is it best practice to have Clustered index on a unique and non-null column or it depends upon the queries the user is going to use?
Hey man tnx for the vid. Can you point out resources to know more about internals of db as a backend dev? (perf tuning, trade-offs, indexing, etc.)
I like the content, I am having a hard time understanding what a page means, page == a file in disk?
Do I see a Katana on the book rack?
Every one showing mysql clustering on youtube(percona xtradb ,galera,group replication,etc).
But i want to do simple write and read replicas and also integrate with demo with frontend+backend app!.
Load balance with all them .
Can some one show me the demo.Oh i am frustrated.!!!!
Please give me proper guide someone...
is it katana in the back?
I liked your old hairstyle. 😅
Finally first
You cluster your data in a table and then Postgre will keep appending inserts?! What the... I thought that the reason behind the clustering was to have data ordered based on some index and KEEP IT that way... I would be ok if they offered a "Append inserts" functionality as a optional behaviour after clustering if you are ok with re-clusteding data once in a while but to do it by default?! If this is the case then what was the point of clustering when you cannot keep it/
I think even a one time clustering could benefit you bc it will rewrite like rows into the same page. So that’s less pages to read which is less IO
"Some of them will get 10" 🤒
Check out my udemy Introduction to Database Engineering course
husseinnasser.com/courses
Learn the fundamentals of database systems to understand and build performant backend apps