This site is about a previous instance of this event. For the current event, please see the updated site.

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.


The following slides have been made available for this session:


Boriss Mejias