search cancel

Slow performance in Resource Planning > Allocations in Postgres

book

Article ID: 201957

calendar_today

Updated On:

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. 

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.

Environment

Release : 15.8.1

Component : CA PPM SAAS RESOURCE MANAGEMENT

Database: Postgres

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: