There are some other issues here that we should look into:
- The retention policy is set up to keep renders for 24 hours. It might make sense to change this to only keep one render, or at least only the renders of a short period (like 10 minutes).
- We only want to retain renders of the latest revision. It might be worth considering to use key_value storage instead of key_rev_value.
Independently, it's worth looking into whether we can optimize the select for the retention policy further, to avoid it being overwhelmed & timing out as easily.