-
Feature Request
-
Resolution: Won't Do
-
Major
-
None
-
6.5.0
-
False
-
-
False
-
CLOSED
-
11,450
-
Undefined
-
Phoenix - Content
Description of problem:
[RFE] Automatic cleanup of logs table
Version-Release number of selected component (if applicable):
Satellite 6.5.2
How reproducible:
In customer environments with a lot of content hosts and puppet check-ins
Steps to Reproduce:
1. We had seen customer environments where logs table contain a ton of data with logs table sometimes consuming more than 35GB.
su - postgres -c "psql foreman -c \"select count from logs;\""
count
----------
539298
(1 row)
Actual results:
Degradation of Satellite performance since postgres queries too long to finish
Expected results:
Logs table should be cleaned up automatically to keep the number of records at an optimum level - say 50k records.
Additional info:
- external trackers