The Project - Task page in Classic UX facing performance issue where it takes more than a minute to open a task and for Non admin users, its timing out.
Release : 16.0.3
STEPS TO REPRODUCE
1. Login to a 16.0.3 machine which has a considerable amount of tasks.
2. Navigate to Projects and open any Project
3. Navigate to Task page and open any Task/Milestone with.without assignments in it.
Expected: The Task page opens in a couple of seconds
Actual: The Task page takes around 1 minute to load and for Non admin users its even timing out
The issue is consistent when the load on system creating Tasks/assignments is high.
The poor performance was due to the bloating on the task tables. PRASSIGNMENT and PRTASK were not included in the pg repack because they dont have a primary key + unique constraints so had to perform a full vacuum after taking down the services.