Uploaded image for project: 'Satellite'
  1. Satellite
  2. SAT-2075

[RFE] Change the way we store reports in PostgreSQL

XMLWordPrintable

      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:

              jira-bugzilla-migration RH Bugzilla Integration
              rhn-engineering-sthirugn Sureshkumar Thirugnanasambandan
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: