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
This portlet uses the system data-provider 'Team Allocations'.
Any portlet that uses this data-provider is slow.
Release : 15.8.1
Component : CA PPM SAAS RESOURCE MANAGEMENT
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.
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