PostgreSQL Partitioning Tutorial

[@FlaviusAspra]

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

[@HighPerformanceProgramming]

Yes, it's 32TB actually. Added the correction in the description but only after publication.

[@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.

[@cassiokendi523]

It's actually 32TB

[@marciomcm2736]

Great video! Very straight to the point.

[@alexgusev8118]

75+ are not old, they are senior 😁

[@olmanmora21]

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

[@timbui5556]

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

[@krazysalsa]

Thank you! efficient and clear tutorial!

[@LuisDiaz-uu7xg]

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

[@TechieTech-gx2kd]

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.

[@vitaliibruelov9490]

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

[@jirehla-ab1671]

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

[@ketanchaudhari5740]

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

[@kevinjia1984]

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

[@raphasteps]

Thanks for the video! Very informative.

[@ivanmatveev4313]

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

[@gomathyelango5574]

Can’t create primary key in partition table?

[@renobodyrenobody]

Excellent, very clear, thank you!

[@aliyevruslan936]

the man

[@shomveerkherwa]

Thank you

[@RealSlimShady-um6gf]

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