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

Conference Schedule - PGConf.EU 2017

Adventures on live partitioning

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.

Slides

The following slides have been made available for this session:

Speaker

Matteo Melli