Table Clustering in MySQL and Postgres - The pros and cons

Published: 19 August 2021
on channel: Hussein Nasser
9,400
358

In this episode of the backend engineering show, I discuss database clustering. This is also known as table clustering, clustered index or Index organized table all names represents the same thing. I will talk about the benefits of clustering and also the disadvantages of implementing clustering. This feature is also implicitly implemented in certain databases.


More readings
https://www.postgresql.org/docs/14/sq...
https://oracle-base.com/articles/8i/i...
https://docs.microsoft.com/en-us/sql/...
https://dev.mysql.com/doc/refman/5.7/...


Become a Member on YouTube
   / @hnasr  

🔥 Members Only Content
   • Members-only videos  

Support my work on PayPal
https://bit.ly/33ENps4


🧑‍🏫 Courses I Teach
https://husseinnasser.com/courses

🏭 Backend Engineering Videos in Order
https://backend.husseinnasser.com

💾 Database Engineering Videos
   • Database Engineering  

🎙️Listen to the Backend Engineering Podcast
https://husseinnasser.com/podcast

Gears and tools used on the Channel (affiliates)

🖼️ Slides and Thumbnail Design
Canva
https://partner.canva.com/c/2766475/6...

🎙️ Mic Gear
Shure SM7B Cardioid Dynamic Microphone
https://amzn.to/3o1NiBi

Cloudlifter
https://amzn.to/2RAeyLo

XLR cables
https://amzn.to/3tvMJRu

Focusrite Audio Interface
https://amzn.to/3f2vjGY


📷 Camera Gear
Canon M50 Mark II
https://amzn.to/3o2ed0c

Micro HDMI to HDMI
https://amzn.to/3uwCxK3

Video capture card
https://amzn.to/3f34pyD

AC Wall for constant power
https://amzn.to/3eueoxP


Stay Awesome,
Hussein


Watch video Table Clustering in MySQL and Postgres - The pros and cons online without registration, duration hours minute second in high quality. This video was added by user Hussein Nasser 19 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,400 once and liked it 358 people.