Clarity: Performance of view ODF_PROJECT_V2 is very slow in PostgresSQL

Products

• Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE: 

1. Create a report by using the simple query on ODF_PROJECT_V2
 
 select * from ODF_PROJECT_V2

2. Ensure the view contains at least 5-10k records 

Expected Results: The query execution should be fast. 

Actual Results:  The query execution on the select will take at least 2-4 minutes

 

Environment

Release : 15.8.1, 15.9 

Component : CA PPM SAAS JASPERSOFT

Cause

This is a defect DE58822 with PostgreSQL database only, Oracle and MS SQL are not impacted. This is currently under review with our engineering team to optimize 

Resolution

Workaround: Use the table inv_projects or odf_ca_project