Add support to create Elasticsearch rolling indexes in visibility

I would like to be able to keep an Elasticsearch cluster performant, manageable, and affordable by having the ES visibility storage provider roll to a new indexname periodically.
ie per month index names might be {namespace}-202301, {namespace}-202302, etc, or per year {namespace}-2023, {namespace}-2024. A configurable user defined pattern that allows custom field values as target indexnames would also be a nice add. There should then be a means to search across a range of indexes (with the default range being configurable, or all?)

This would allow searches to target the indexes by date range (or custom field etc) thereby being much more efficient. This would also allow automatic ES migration of older content to cheaper ES tiers, or archiving them.

Describe alternatives you've considered
I am not aware of any real alternative.