Date: 2019-03-21
Time: 13:50–14:40
Room: Conference Room
Level: Intermediate
Feedback: Leave feedback
Partitioning refers to splitting what is logically one large table into smaller physical pieces. Partitioning can be utilised in many ways and provide performance benefits in scenarios when used properly. Partitioning can not only be a complex feature to implement, but can also be difficult to understand when it can be beneficial and when it can be a great big headache!
This session will not only enlighten you on how to implement partitioning, but will help you with the decision of when you should or shouldn't be using it in PostgreSQL. PostgreSQL 11 has a much improved implementation of partitioning, we'll look at some of these improvements and how you can make the most of them to support your applications.