Time: 11:50 - 12:40
In this talk, I will describe my nowadays production architecture using
pg_partman trigger-based partitioning technique on PostgreSQL 9.5.
This database stores all sales eventof DECATHLON sport retail company for several years. Containing more than 250 millions sales events and increasing fastly...
In order to take the benefits of the improvement of the last PostgreSQL version regarding partitioning in particular...
I'm studying opportunities of improving the partitioning model of the database, using native partitioning and/or available extensions for trigger based partitioning or tooling.
In this talk, I will: - introduce my database structure - present 9.5 partitioning - explain improvement on partitioning on PostgreSQL11 - analyze possible solutions and focus on several solutions - provide feedbacks regarding these solutions regarding - perfomance impact - side effet of database administration - migration technique
Here is a plan of my presentation:
Mix partitioning solutions together
From a single storeID-based partitioning to a double-axis partitioning (storeID+time)?