Support Article
System crashes when using Pega List View query on Postgres
SA-65621
Summary
Pega List View Query takes 53 seconds on Postgres and the system crashes. However, on Universal Database (UDB), List View Query takes only two seconds.
Error Messages
Not Applicable
Steps to Reproduce
Unknown
Root Cause
Missing index on the column used in the Join condition of one of the class Joins.
Resolution
As a local-change, add the missing index to the database.
Published October 5, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.