Change the record expiry time per table

To reduce or increase the number of records stored in the database for a particular table, change the duration of time that a record is stored in the database for this table before it is purged. The duration only applies to this particular table.

  1. Navigate to the specific <Table> tag with the TableName attribute matching the table that you want to change.
    For example:
    <Table TableName="RESOURCE_METRICS" TimestampColumn="TIME_STAMP" ... />
  2. Add or edit the Duration attribute with your desired time in days, up to a maximum of 31 days.
    For example, to have the records in this table purged after 10 days:
    <Table TableName="RESOURCE_METRICS" TimestampColumn="TIME_STAMP" Duration="10" ... />
  3. Restart the purger service.