Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Pega Marketing portal UI freezes on big volume of Customer data



Performance issues related to volume of data occurred in pre-production server configuration. Some actions in Pega Marketing portal freeze after adding approximately 112 million users. These actions include opening Audience landing page, creating Segment, and opening and refreshing Campaign landing page. The portal freezes from two to five minutes.

Error Messages

Not Applicable

Steps to Reproduce

1. Insert approximately 100 million rows in custom table.
2. Create index on primary key.
3. Explain (Analyze) select count (CustomerId) from table.
4. Check estimated time and navigate over Pega Marketing portal.

Root Cause

A defect in Pegasystems’ code or rules. This is a known issue with PostgreSQL. Refer the page on Slow Counting from PostgreSQL wiki page. Pega Marketing uses count(*) in Audience tab loading, which scans the table completely and takes time to complete.
A poor performance of Connect-Sql rule "RULE-CONNECT-SQL RULE-OBJ-REPORT-DEFINITION-SEGMENT ORACLE!COUNTROWS #20150910T222420.514 GMT" was identified. It executes the query "select count(1) from {class:CustomerData}" that takes a lot of time to execute in PostgreSQL DB.


Perform the following local-change:
1. Update the query to use Estimated count feature of PostgreSQL.
2. Save as the Connect SQL rule “Rule-Obj-Report-Definition-Segment • oracle • CountRows” to local ruleset, and update the Open SQL query as follows:
SELECT reltuples::BIGINT as ".pyValue" FROM pg_class WHERE oid = '{class: {.pyName}}'::regclass;
3. Run Analyze and Vacuum commands whenever updating Pega Marketing custom table to keep estimated count and count in synchronization.

Published August 23, 2017 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us