> Is there anyway to cut down on what is logged in these tables and/or > periodically purge them? Our event table alone is 81,440,723 rows (!).
We run a daily cron job to truncate records older than 60 days. Here's the PostgreSQL statement we use: delete from com_audit_trail where aud_date < now() - interval '60 days'; M -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
