I've noticed that under a high volume mail server using policyd, with the cleanup app running each hour, the operation can take some time to complete, which bogs down the database server considerably. I would like to change the cleanup script to run once daily instead in the middle of the night.
Although, in the source code all the cleanup queries have LIMIT 100000 on them. Not a problem when running it hourly, but daily this could cause issues becuase the database may grow faster than 100000 entries per day. example line 74 of cleanup.c: "DELETE QUICK FROM triplet WHERE _datelast < %d LIMIT 100000", The limit command seems counterproductive. I can remove it from the source of my installation easy enough, but I would suggest it be removed from the distributable source as well unless there's a great reason to keep the limits. - Nate ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ policyd-users mailing list policyd-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/policyd-users
