Date: 2017-10-25
Time: 17:20–18:10
Room: Congress
Level: Intermediate
This talk is about a success story of partitioning an existing PostgreSQL 9.6 1B rows table, live, in production, running on Amazon RDS.
The talk will present how the partitioning was designed, the analysis steps done while testing the best approach to move the data and why we ended doing a live partitioning instead of a more secure offline partitioning. We also will see how we would have done that using PostgreSQL 10’s new partitioning features.
The following slides have been made available for this session: