I am reviewing the retention process that we have in place and the pilerpurge utility is getting the job done as expected. However, I notice in the documentation that the metadata record in the database simply has a column that marks the message as deleted. The metadata record remains.
What If I don't want to retain the metadata? Is there a utility or sql script for cleaning up metadata for purged messages? Looking at the mysql database schema, I see three likely candidates for tables that would need purging: metadata, rcpt, and attachment. Thanks, Jeff
