Table Partitioning in Postgres: How Far We've Come

Table partitioning is an important tool for developers and DBAs to deal with big and growing database tables. Postgres has for a long time allowed users to implement table partitioning in their databases, but doing so wasn't very easy until Postgres 10, which featured a new DDL syntax for partitioned tables. Postgres 11, 12, and upcoming 13 made significant strides to make partitioning usable enough, both in terms of features and performance, for users to seriously consider it in production.
In this talk, I will describe partitioning as a tool to solve certain problems. Also, as one of the authors of the new partitioning, I will describe its implementation in Postgres and challenges that remain.

Видео Table Partitioning in Postgres: How Far We've Come канала EDB