Under Community Review

There are opposite views and feature request about this:

https://community.rws.com/ideas/tridion-ideas/i/tridion-sites-ideas/permanent-publish-data

https://community.rws.com/ideas/tridion-ideas/i/tridion-sites-ideas/retrieve-the-complete-publishing-history

I would like to get more insights from the community to understand why you would want to preserve or auto-delete publish transaction data. There seem to be customers that will need to preserve more information about the content lifecycle including when content was published, republished and unpubilshed, as well as some voices that just see historic publish transactions as clutter.

Auto delete old Publish Transactions

There should be an option where Tridion would delete Publish Transactions after some time so that they are not stored indefinitely in CM database.

My suggestion would be auto option where configurable timeframe would be in Tridion Content Manager Config. In this regard, publisher service would be extended to remove old Publish Transactions.

Other, less optimal option would be to have a tool provided by SDL. Something like "remove old versions of items" tool. In this case admin would run this tool from time to time, or set its execution period.