@Christian_Dahlqvist: I tried running the iostat -x when the load test is running and got the below output.
I don't think that the disk is the bottleneck.
The write throughput after the test was started:
The read throughput after the test was started:
We are able to index at the speed that we want but are not able to query. The read requests are really low. Is there anything that could be an issue here or something that you feel should be changed in the settings or so. And let me know if you need anything else from my side to debug this.
Thanks,
Suril