Support Article
Performance degrades when working in a cloned environment
SA-74473
Summary
Performance degrades when working in a cloned environment.
Error Messages
Not Applicable.
Steps to Reproduce
- Clone an environment
- Check in or check out the code
Root Cause
There was a type cast exception that resulted in database connection leak (connections are not returning to pool).
The pr_engine_classes, pr4_rule, pegadata.pr_index, pr4_rule_sysgen tables are fragmented and pr_engine_classes alone consumed 84% CPU.
Resolution
Perform the following local-change:Remove the bloat in all these tables and tune Autovacuum (vacuum threshold and worker threads) post to the activities.
Published August 19, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.