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.
The following slides have been made available for this session: