Close popover
Mohan Pawar (MohanP1794)
Aaseya IT Services Pvt. Ltd.

Aaseya IT Services Pvt. Ltd.
MohanP1794 Member since 2014 5 posts
Aaseya IT Services Pvt. Ltd.
Posted: May 19, 2020
Last activity: May 25, 2020

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.



Mohan Pawar

Pega Platform 7.3.1 Conversational Channels Manufacturing