Conference Schedule - Nordic PGDay 2022

Table Partitioning - Transparent but No Magic

Date: 2022-03-22
Time: 16:05 - 16:55
Room: Ballroom

When a table gets too large, performance and maintenance is heavily affected. Splitting the table into multiple partitions to achieve the desired performance. Table partitioning has been supported in PostgreSQL since many years as a design pattern of table inheritance, which is complex to use correctly, and didn't benefit from any parallelism. Since PostgreSQL version 10, there is support for declarative table partitioning, having new features in improvements in later versions. Table partitioning is now much easier to use and there are more use cases covered. 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.

Slides

The following slides have been made available for this session:

Speaker

Boriss Mejias