Recommend creating a table per utc day for logs. Maintenance is a matter of dropping old tables.