Performance degrades when working in a cloned environment
Performance degrades when working in a cloned environment.
Steps to Reproduce
- Clone an environment
- Check in or check out the code
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.
ResolutionPerform the following local-change:
Remove the bloat in all these tables and tune Autovacuum (vacuum threshold and worker threads) post to the activities.
0% found this useful