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
bit.ly/33ENps4
Become a Patreon
/ hnasr
Stay Awesome,
Hussein

[@cadddie-ai]

I have never seen a KZbinr with so much backend knowledge, experience and a succent manner of presenting ideas.

[@GoddamnAxl]

People around Hussein: look he's doing vlog! Let's go check out what he's talking about this beautiful place! Also people: wtf

[@RohitSaini52945]

The only individual whose videos I watch in their whole without forwarding or adjusting the playback speed.

[@RanjithVj404]

I thought querying the correct partition needs to be handled by the application. The post-production bit cleared the doubt. Thanks!

[@alexkim7270]

My, my ! If I were at that beach, I'll sit down quietly near you to hear it.

[@saiteja-gu2qr]

Happy new year Nasser. Your content is very underrated.

[@hnasr]

sai teja thank you so much! Glad you are enjoying the content, happy new year 🎊

[@bsen2267]

Thanks Hussein, you are my best teacher!

[@muskduh]

Great free video!! Thank you!

[@Diarmuidism]

This was a big help, thank you.

[@hnasr]

Glad I could help Diarmuid! 😊

[@ynternet1]

Thank you so much for this video!!!

[@sweathajeyaprakash1814]

Really amazing post simple & clear !! keep the good work:) Big Big thank you

[@hnasr]

Sweatha Jeyaprakash thank you for your comment 🙏 glad you liked the content

[@mrkiwiboy2011]

Loved the post note ! thank you

[@hnasr]

Thanks Marie 🙏

[@WafaPRO]

Amazing start

[@MsAneesh007]

Thank you!

[@aminalakhras]

I love you ! Thanks

[@dhenukarangam2799]

Awesome 👏

[@true_fact_100]

Thanks a lot it was big help... wish there was a video on Horizontal Partitioning vs Sharding.. based on this video.

[@hnasr]

Amay Shanbhag thanks !! There is a video on Sharding Database Sharding Crash Course (with Postgres examples) kzbin.info/www/bejne/mmLJiXWCptN5rMU

[@ParthPatel-fp8lm]

Hello, thanks for the video. I have one question. In vertical partitioning, we need to keep partition key also along with the large columns to separate, correct? If we do not keep partition key, how will it search in that column?

[@mShady]

Just watched your sharding video and now watching this one. Awesome stuff! Just a quick question, isn't vertical partitioning just the old good db normalization? Or am I over simplifying?

[@hnasr]

Interesting, if you think about it its actually is normalizing at data model level (how you see it as a user) vs vertical partition is done at the deep database storage level which is not visible to you as clearly. good thoughts

[@timbui5556]

Hi Hussein, thank you for making this instructional video. We can find many sources on the web how to do horizontal partitioning. Can you show us where we can learn how to do vertical partitioning in Postgres? Thank you again!

[@nathanbenton2051]

Awesome video! Comparing this stuff to the overall Snowflake architecture would be quite interesting - is something like that possibly on the roster for future videos?

[@markarmon2883]

Fansatic!

[@brandonjarrett4314]

Hilarious and informative.

[@yanetfors1007]

Hi Hussein. Thanks for this amazing video. I have a doubt if I need to do a partition by range based on a date column, how should I know what is the best range? For instance partitioning by weeks or months ?

[@yanetfors1007]

I suppose you should check the numbers of rows, but which would be an acceptable number of rows for a partition and which won't?

[@aldosusanto]

Correct me if im wrong, but I think there are better methods to solve the vertical partitioning problem (where we have a heavy blob column), I came up with two: 1) I believe we can just use JPA Projection to query specific columns only, so when we do the query, we dont have to take all the columns of that entry, we just grab the columns that we need. 2) What about creating another table just for the blob column then (with an FK connecting both tables of course) ? I know that this seems like a messy solution, but isn't vertical partitioning also as messy? :) Is vertical partitioning still better than both cases above? if so, why ?

[@hnasr]

Vertical partitioning is what you described in 2 You can of course query for what you want but your paying cost of storage of that blob field in your table space

[@NineBerry]

Shards event coming?

[@B-Billy]

Watching it on 1st January, 2020😂

[@patricknebe6030]

🤣 *2021

[@MrElipis]

2023

[@weevolve4180]

Lost brother of Hugh Jackman😂

[@bd3723]

Great video but had to just listen instead of watch because got kinda motion sick :(

[@hnasr]

Sorry about that, I made a better video on partitioning that will come in the coming weeks

[@bd3723]

@@hnasr oh no worries! Just constructive feedback! Totally grateful for the content 😊