Store Gateway PVCs Fill Up Frequently, Require Recommendations #5262

Describe the bug
Store gateway PVCs in our Cortex project are filling up frequently, forcing us to repeatedly increase the size of the PVCs. We are seeking recommendations to resolve this issue.

To Reproduce
Steps to reproduce the behavior:

1. Start Cortex (SHA or version)
2. Perform Operations (Read/Write/Others)
3. Monitor store gateway PVCs usage
4. Observe frequent filling up of the PVCs, requiring manual intervention to increase their size

Expected behavior
We expect the store gateway PVCs to have a more stable and manageable growth rate that does not require constant manual intervention.

Environment:
Infrastructure: Kubernetes
Deployment tool: Pulumi

Issue
Store gateway PVCs are filling up frequently, forcing us to increase their size regularly. We are requesting recommendations to manage or mitigate this issue more effectively.