Skip to main content

Table of Contents

Trimming and purging tables


Only available versions of this content are shown in the dropdown

You can trim or purge tables by using an SQL query tool. In a development system, using an SQL query tool is fast and often appropriate. As a best practice in a production setting, implement trimming and purging operations using activities, either run on request or run automatically by an agent.

Using an activity might be slower and more resource-intensive, but it helps ensure database integrity, handles errors, and causes internally maintained Index- instances to be deleted appropriately by Declare Index rules.

You can use the standard activity Log-.TrimLog to purge instances of one concrete class derived from the Log- base class, retaining instances less than N days old, where N is a parameter to the activity. This activity records the number of records trimmed in the Pega log file.

The Pega-RULES agent normally runs the standard Code-.SystemCleaner activity once each day for housekeeping tasks. You can add a similar activity to another agent in your application to purge outdated information and recover table space. Make sure that the new agent has access to the appropriate ruleset versions, and do not purge records that are referenced in other tables.

Work item purging

Work item details are stored as rows of many different tables. To purge work items, it is important to remove all the pieces, and to remove only those work items that are not active.

Case archiving and purging

This functionality is Pega Cloud only.

For case items, use the case archival feature.

For more information, see Improving performance by archiving cases.

Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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