Question
VODTR
TR
Last activity: 7 Sep 2022 3:42 EDT
Delete PR_History Table
I plan to delete the Pr history table as it takes up too much space, but I have a few questions about it. Is there a job for the Pr History table? / is it working? What are the effects of deleting the table? How can I delete it and is there a data date that needs to be kept for deletion? i.e. last 30 days data should stay in table
***Edited by Moderator Marije to add Capability tags***
Updated: 6 Sep 2022 17:37 EDT
Pegasystems Inc.
US
@BatuhanAlkin Not advised to delete the table
More info available here: History tables | Pega
The
pr_historytable has only a few exposed columns. As a best practice for good performance, configure your Pega Platform database so that classes with a high volume of saved instances or activity are not mapped to this table. Ensure that this table does not contain history instances for work items or data objects. Some applications might have thousands or millions of history records for high-turnover classes such as interest rates. As a best practice, create dedicated tables with exposed columns for such classes
ING Bank N.V.
NL
@BatuhanAlkin Deleting the table would make most of your instance classes failing any kind of CRUD operations. Your issue should be with the volume of data in the table, not the table itself.
Approach 1: You can run a manual truncate query every 15 days which will remove records older than 30 days.
Appproach 2 : Create a Job Scheduler which will run the truncate query automatically,