A Deep Dive into Table partitioning 🐰 Part 3: Maintenance Under Pressure

In our previous article for this series, we discussed how we do maintenance on partitioned tables, where uptime is our biggest priority. To help you accomplish the same without the same amount of work, we shared all the functions we created over time in our public GitHub account. Minimizing the impact of partition maintenance on the application locking is a very important concept to understand. In this article we go through some very basic locking principles, and how they apply to partitioning. We zoom in on a few situations where locking caused us some challenges, and how we mitigated them; for example, when attaching new  partitions, or having to deal with  the infamous default partition.