Conference Schedule - PGConf.EU 2022

Table Partitioning - Transparent but No Magic

Date: 2022-10-28
Time: 13:40–14:30
Room: Berlin 1
Level: Intermediate

When a table gets too large, performance and maintenance is heavily affected. That's why you want to split the table into multiple partitions before the problem hits you. Good news is that PostgreSQL has great support for declarative table partitioning. It is easy to use and it is transparent to the application, however, there are some caveats you want to be aware of, as there is no magic in this solution. In this talk, we will review with concrete examples how you would benefit from table partitioning, how to use declarative partitioning, and what are the implications of taking some decisions when designing the schema.

Speaker

Boriss Mejias