we have set the Retention policy to 100 releases in Octopus life cycle. Currently we have 100 MB space on database so that Octopus is much slow in performance. tblEvent and tblDeployment history have more number of rows. Could you please advise how to delete the records in these tables.
If those tables are becoming too large, then the best option would be to reduce the retention policy to below 100 releases until the database is at a manageable size.
It may also be worth checking all of your projects and lifecycles to ensure that the retention policy is applied across them all.
Thanks for the update. In one life cycle the retention policy was 5 releases and i could see releases are getting deleted for the project. But the deployment history table it has 60K records for that project and i am not sure why the records are not deleted in deployment history table.
How often are the release for this project deployed? Is it something that often gets deployed frequently?
If you check the entries in the deployment history table for this project do they belong to the currently existing releases?
We don’t recommend deleting data from the database directly, but, if you are certain that these records are for releases that don’t exist anymore then you could remove the rows.
Obviously, ensure you take a backup of the database first, so, that you are able to perform a restore if anything does go wrong.