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***
The pr_history table 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