1
00:00:00,030 --> 00:00:07,350
‫Partitioning or database partitioning is a technique where you split up a huge table into multiple tables

2
00:00:07,350 --> 00:00:13,710
‫and let the database decide which table or which partition to hit based on the where clause.

3
00:00:13,740 --> 00:00:19,710
‫It is a very, very genius design and I'm going to discuss it in this video about we jump into it.

4
00:00:20,190 --> 00:00:23,130
‫So we're going to discuss in this particular video, guys.

5
00:00:23,340 --> 00:00:25,070
‫So what is partitioning?

6
00:00:25,080 --> 00:00:26,460
‫Why does does it exist?

7
00:00:26,470 --> 00:00:28,170
‫Because that's the question we always ask.

8
00:00:28,350 --> 00:00:30,720
‫Why does any technology exist?

9
00:00:31,650 --> 00:00:36,240
‫All right, we're going to ask what is what is so that we're going to talk about horizontal partitioning

10
00:00:36,240 --> 00:00:37,760
‫and vertical partitioning, guys.

11
00:00:37,980 --> 00:00:40,850
‫So that's that's a very, very critical concept drawing.

12
00:00:40,860 --> 00:00:46,110
‫What was the difference between the and from now on, whenever I say partition, I'm always referring

13
00:00:46,110 --> 00:00:47,220
‫to horizontal partition.

14
00:00:47,220 --> 00:00:53,220
‫And that's why people rarely use vertical partitioning, because it's just it's like normalization,

15
00:00:53,220 --> 00:00:56,130
‫almost like vertical partition, partition types.

16
00:00:56,140 --> 00:00:58,230
‫What kind of types of partitioning we have?

17
00:00:58,230 --> 00:01:01,530
‫What can what can we do to do partition in different kind of partitioning?

18
00:01:01,800 --> 00:01:06,750
‫Then we can describe partitioning versus Sharding, which is another video I discussed that specific

19
00:01:06,750 --> 00:01:09,390
‫to Sharding a little bit more complex than partition.

20
00:01:09,390 --> 00:01:11,550
‫I'm going to explain the difference between the two.

21
00:01:11,550 --> 00:01:16,350
‫We're going to do a demo because that's a beautiful thing that he was postgres to do a demo, show you

22
00:01:17,280 --> 00:01:21,150
‫a table with 10 million rows and how to partition that stuff.

23
00:01:21,740 --> 00:01:26,100
‫I'm going to discuss finally the pros and cons and then summarize the whole thing.