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

[RFE] remove cp_event table, collection and Change endpoints that return events to return empty lists.

XMLWordPrintable

    • None

      This table grows unbound over time resulting in gigabytes of largely unecessary data. From an example customer who has a 2Y old Satellite installation with 20,000 consumers/hosts

      table_name | total | index | toast | table
      ------------------------------------------------------------------------
      cp_event | 12 GB | 5682 MB | 8192 bytes | 6484 MB

      select count from cp_event;
      count
      ----------
      25,017,125

      We need a policy and procedure in place to delete anything in this table over ~7 Days (or configurable value) as it is no longer something that needs to be stored.

              jira-bugzilla-migration RH Bugzilla Integration
              jira-bugzilla-migration RH Bugzilla Integration
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: