Question

3
Replies
83
Views
MohanP1794 Member since 2014 5 posts
Aaseya IT Services Pvt. Ltd.
Posted: 4 months ago
Last activity: 4 months ago

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

Pega Platform 7.3.1 Conversational Channels Manufacturing and High Technology
Share this page LinkedIn