A Deep Dive into Table partitioning 🐰 Part 4: How the default partition saved the day

In the previous blog posts, we discussed the ins and outs of table partitioning in Postgres. We touched on different types of partitioning, how to partition tables of several terabytes(TB), and how to automate partition maintenance.

Today, we’ll dive deep into another story where partitioning saved the day at Adyen. While partitioning is a great strategy for dealing with scaling issues, it can become a problem on its own. Nonetheless, once it’s well understood and experimented with over time, it can offer a powerful set of tools that were not available before.

It’s good to mention that all the practices we’ve recommended so far should be followed for a “boring” life (remember, boring is good in our world). However, sometimes, we must go around the best practices and push our knowledge to its limits. Sometimes, we need to get creative; this story is a great example of when we did so.