Consider partitioning strategies for description_versions
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, description_versions
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
description_versions
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
description_versions
?
Edited by Matt Kasa