Question
System processing is becoming very slow in production
Hi Team,
On an average, we are creating 5-7 million cases every day. Most of the day, this process works fine but sometime in a week the processing becomes too slow. I do not see anything wrong happening in the pega logs, also it is not an issue with the load as we are processing more than 8 million data without any issues.However, the issue gets resolved after RDS restart.
During this time the overall connections with postgres seems to be around 1k (20-90 active connections+800-900 idle connections ) however, the connection pool size is set to 5k for postgres it seems. I am not really getting how RDS restart is helping here.
I understand that, this is not that straight-forward but any guidance or clue will be highly appreciated.
Note: We have a process which runs every hour to delete idle connections older than 20 minutes.
Thanks,
Mohan Pawar
What does the postgres performance analysis say?
Is it being allowed down because of long running queries?
Or is it because of too many queries?
Regards,
Murali