PostgreSQL Partitioning Tutorial

Fix: The maximum table size is 32TB and not 32GB. (for default 8 K blocks)

0:00 - Introduction
0:59 - Which Tables Need Partitioning?
3:05 - How should the Tables be Partitioned?
4:52 - Declarative vs. Inheritance Partitioning
5:37 - Creating a Partitioned Table
9:58 - Partitioning Methods

🐘 Want to find out MORE about Scaling PostgreSQL?
Use the link below to get 60% OFF on the Entire Course.

[olmanmora]

Great introduction to partitions in postgres, they are quite helpful for large tables and also for archiving data.

[marciomcm]

Great video!
Very straight to the point.

[krazysalsa]

Thank you! efficient and clear tutorial!

[timbui]

Thank you for making a very informative video on partitioning. Can you teach us how to do vertical partitioning in Postgres as well (or point us to where we can find that info)? Thank you

[LuisDiaz-uuxg]

Hello
very nice video.
Can you tell us how to partition a table by range with 2 fields ? And then insert data from source table to the new partitioned table?
Many thanks

[FlaviusAspra]

What's with 32 GB? I have a table of almost 500 gb in production.

[santattech]

You mentioned 32 GB for a table size restriction but later you mentioned when the table size is 200 GB, we should consider partitioning, can explain this please? I am confused.

[raphasteps]

Thanks for the video! Very informative.

[ivanmatveev]

Thanks!! It's a really great explaining!)

[kevinjia]

Try to List partition a table (which has a primary key) on a non primary column, but seems like not working. That partition field has to be in the primary key or we need to drop the primary key in the table

[TechieTech-gxkd]

01:52 are you referring to the size of the table > 200 GB or was it the response time 200ms, because if it was size then its contradictory
to your statement on size of postgres table with 8KB block size can't be crossing 32GB in size.

[ketanchaudhari]

Suppose there is a table (A) with 2 partitions (B) and (C) at a time suppes we are truncating partition (B) and select data from table (A) of partition (C) is it possible or we will get dead lock issue

[jirehla-ab]

How about an accounts table containing 1 million records or more where the account balance is frequently updated, is table partitioning advisable?

[gomathyelango]

Can’t create primary key in partition table?

[vitaliibruelov]

In your age example, to which partition will be inserted 25 years and 75 years? Why didn't you emphasize this important aspect?

[RealSlimShady-umgf]

Master slave partition doesn't work on Ubuntu if master goes down and slave doesn't become master. Any thoughts on how to make slave as master