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