PostgreSQL process in Clarity is slow

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

A process that updates records in bulk via XOG is slow in Clarity on the update statement. The records are updated in a large custom object table and there is multiple changes to the records throughout the process

Resolution

• Incorporate a separate step that would run vacuum analyze on the custom object table in between the specific updates 
• This would improve the performance of each statement significantly