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…
Translate
