Skip to content

Consider partitioning strategies for resource_label_events

Due to the ongoing increased load issues on the primary, we need to take action to reduce the load. One of the solutions we're considering is partitioning tables > 100GB. As a very large table, resource_label_events has been selected as a candidate. For more information on available strategies, please review our docs

We'd like to answer the following questions:

  • Does resource_label_events have a key that would be easy to partition on?
  • What strategy seems like the best bet for partitioning this table?
  • Are there other strategies we'd like to consider to reduce the size of resource_label_events?
Edited by Matt Kasa