We have a lot of old audit items in our database that were generated by Automation for Jira. We were going to try to follow the instructions from this guide to delete old audit items but we encountered a problem.
https://confluence.atlassian.com/automation/expire-audit-log-items-993924681.html
Our DBA was going to try to delete old audit items directly from the database, but he found that there was a foreign key relationship on a related queue table [AO_589059_AUTOMATION_QUEUE] that references one of the audit log tables. In order to delete the audit records, he said he would have to remove the foreign key, delete the records, then add it back. Is this safe to do or is this article out of date? We would like to perform this operation in the most performant way possible.