Performing Maintenance Tasks

You can use the Maintenance Tasks page to perform these maintenance tasks.

  • Pause Operations - Sometimes it can be useful to pause import, without stopping the database entirely. This allows you to manually re-cluster or re-index tables, or avoid errors when the Intermapper Server goes down for maintenance. Specify the interval for which you want to pause, then click Pause Operations. A Resume Operations button and countdown clock appear. To resume operations at any time, click Resume Operations.
  • Data to Delete - Data retention policies are the recommended way to free disk space on a per-dataset basis. You can also delete data or events across all devices, or you can delete data for deleted devices and interfaces. Please be aware that this operation is permanent and cannot be undone. Specify which data you want to delete (raw data, data samples, events, or date from deleted devices), and a time period over which you want to delete them, then click Delete.
  • Apply Retention Policies and Reclaim Disk Space- Retention policies are applied daily, and a maintenance task runs once each week to reclaim unused disk space. You can run both of these tasks manually using these buttons. Both operations can take from a few minutes to a few hours to complete, depending on the size of your database. See About Automatic Maintenance Tasks below for more information.

Two tasks run automatically to clear out data that is beyond its retention policy expiration, and to reclaim unused disk space.

  • Daily task - runs at 1AM local time each day. It applies retention policies, then uses the PostgreSQL VACUUM command to mark free space for re-use by the database. This is a relatively low-impact process, and does not pause database operations. It does not release disk space for reuse by the operating system.
  • Weekly task - runs at 1AM local time each Sunday. It uses the PostgreSQL CLUSTER command, and pauses database operations while it runs. This task frees up unused database space, making it available to the operating system.

After you run one of these tasks, the Disk Usage table shows the freed disk space as available.