‫Partitioning or database partitioning is a technique where you split up a huge table into multiple tables
‫and let the database decide which table or which partition to hit based on the where clause.
‫It is a very, very genius design and I'm going to discuss it in this video about we jump into it.
‫So we're going to discuss in this particular video, guys.
‫So what is partitioning?
‫Why does does it exist?
‫Because that's the question we always ask.
‫Why does any technology exist?
‫All right, we're going to ask what is what is so that we're going to talk about horizontal partitioning
‫and vertical partitioning, guys.
‫So that's that's a very, very critical concept drawing.
‫What was the difference between the and from now on, whenever I say partition, I'm always referring
‫to horizontal partition.
‫And that's why people rarely use vertical partitioning, because it's just it's like normalization,
‫almost like vertical partition, partition types.
‫What kind of types of partitioning we have?
‫What can what can we do to do partition in different kind of partitioning?
‫Then we can describe partitioning versus Sharding, which is another video I discussed that specific
‫to Sharding a little bit more complex than partition.
‫I'm going to explain the difference between the two.
‫We're going to do a demo because that's a beautiful thing that he was postgres to do a demo, show you
‫a table with 10 million rows and how to partition that stuff.
‫I'm going to discuss finally the pros and cons and then summarize the whole thing.