Since PostgreSQL introduced partitioning with version 10, it has become one of the most popular features.
But my experience is that many people don’t understand how to use partitioning properly. This leads to disappointment.
In this talk I will show the essential features of partitioning, but I will focus on the best pitfalls to avoid and how to do it better.
Database consulting, training and development for CYBERTEC since 2017.
Maintainer of the Oracle foreign data wrapper.