> When i stress test it with 500 concurrent request, then after 150 - 160 concurrent connections my > database enters into recovery mode and it fails the request. For my stress test i am trying to get > data from one table. > > Do you guys have any idea what is causing the problem or if i am missing some other configuration?
The database does not go into recovery mode just like that. Look into the database log and see if you can find the appropriate messages, then we can figure out what caused the problem.