Slow performance in Resource Planning > Allocations in Postgres

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Slow performance in Home > Resource Planning > Allocations for some users. This may be noticed also trying to get to the Weekly Detail portlet which is on the Allocations tab. 

STEPS TO REPRODUCE

1. Go to Home > Resource Planning > Allocations screen. This screen is extremely slow to load.

This portlet uses the system data-provider 'Team Allocations'.

Any portlet that uses this data-provider is slow. 

Environment

Release : 15.8.1

Component : CA PPM SAAS RESOURCE MANAGEMENT

Database: Postgres

Cause

The team provider builds a query, if many parameters are included, the query will include joins, which are slow on Postgres. This was logged as DE56270.

Resolution

Database setting has to be changed to improve the performance:

join_collapse_limit has to be increased from 8 to 10 on all PostgreSQL databases

Additional Information

See also:

• Resource Planning portlets performance troubleshooting
• Resource Planning portlets slow with 'Instance' or 'OBS' access
• If you are seeing slowness specifically in entering data in Time-Scale Value (TSV) fields, see also Weekly Detail Portlet Slow updating data in TSV
• Slow Performance in Clarity - best practices / known issues