-
Bug
-
Resolution: Done
-
Critical
-
None
-
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.