Скачать или смотреть Horizontal vs Vertical Database Partitioning

In this video I explain what database partitioning is and illustrate the difference between Horizontal vs Vertical Partitioning, benefits and much more.

0:00 Intro
1:00 Why Partitioning?
3:00 Horizontal Partitioning?
5:50 Vertical Partitioning?

Benefits of Partitioning
Indexes are smaller (quick index scans)
Allows DB optimizer to sequence scan the partition instead of index
Split table by columns (vertically) and put the columns with the entire slice into another table (blobs) Example fields that are blobs can be put in another table in another tablespace that is stored in hard disc vs the rest of the data goes to your SSD



Types
Range partitioning
Range queries within a key ..

List partitioning
Discrete values- countries

Hash partitioning
Consistent hashing based on a value, hard to add to new partition




🏭 Software Architecture Videos
   • Software Architecture  

💾 Database Engineering Videos
   • Database Engineering  

🛰 Network Engineering Videos
   • Network Engineering  

🏰 Load Balancing and Proxies Videos
   • Proxies  

🐘 Postgres Videos
   • PostgresSQL  


🚢Docker
   • Docker  

🧮 Programming Pattern Videos
   • Programming Patterns  

🛡 Web Security Videos
   • Web Security  

🦠 HTTP Videos
   • HTTP  

🐍 Python Videos
   • Python by Example  

🔆 Javascript Videos
   • Javascript by Example  

👾Discord Server   / discord  

Support me on PayPal
https://bit.ly/33ENps4

Become a Patreon
  / hnasr  

Stay Awesome,
Hussein