Any idea how the event and event_log are used by CAS?  I'm not sure these
are the same tables others are referring to.


On Wed, Mar 13, 2013 at 3:00 PM, Marvin Addison <[email protected]>wrote:

> > 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
>

-- 
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

Reply via email to