system_log and system_log_detail tables too large

[Yajasi]

We are hosting TimeTrex on a Ubuntu 14.04 server. The PostgreSQL database indicates that the following two tables have grown quite large.

Code: Select all

system_log	 - size 1,936,834,560
system_log_detail	 - size 2,731,417,600

This is approaching nearly 5 gig of space devoted to log files. Can these log tables be trimmed in some way?

[shaunw]

Those tables are used for the audit log, while you can delete all records from them if you like (though we highly recommend against it), its virtually impossible to delete just "some" of them without compromising the audit log and making it essentially useless.

Put in perspective, 5GB is an extremely small amount of data.