Full Load DWH Performance Issue for DWH_FIN_PLAN_PERIOD_FACTS (Postgres)

Products

• Clarity PPM SaaS

Issue/Introduction

The full Load DWH job slow performance occurs on the table DWH_FIN_PLAN_PERIOD_FACTS

STEPS TO REPRODUCE:

1. Login to large Postgres Clarity System.

2. The dataset should have at least 3+ Million rows on dwh_fin_plan_per_facts_v view on the PPM Schema.

3. Run the DWH Full Load.

Expected Results :- Full Load completes within reasonable amount of time

Actual Results :- Full load takes a very long time for DWH_FIN_PLAN_PERIOD_FACTS and certain cases, times out.

 

Environment

16.4.0

Cause

DE176194

Resolution

This is resolved in 16.4.2