We are evaluating using temporal as a workflow orchestrator for a new OMS.
I can see the following statement in the documentation:
Elasticsearch supported versions. We recommend operating a Temporal Cluster with Elasticsearch as your Visibility store for any use case that spawns more than a few Workflow Executions.
Is this realistic?. I guess ES might be used for having have quicker and more accurate searches , correct?
I would expect temporal cluster uses a dedicated database (MySQL, Postgres or Cassandra) for core functionalities and performance will be similar for those databases.
Also is there some benchmarks about how advanced visibility performs in ES in comparison with other databases?
Many thanks in advance.