I am using elasticsearch as primary database. But due to the lack of the ACID properties, I want to:
- or replace it with another database with similar or better performances ( maybe postgresql or kafka/ksql ).
- or use other solution together with elasticsearch to avoid the loss of data ( due to the lack of the ACID properties ).
So what is the better solution? and how can I check what are the performance differences between ElasticSearch and the other solution?