TimescaleDB includes a background job scheduling framework for automating data management tasks, such as enabling easy data retention policies.
To add such data retention policies, a database administrator can create,
remove, or alter policies that cause
drop_chunks to be automatically executed
according to some defined schedule.
To add such a policy on a hypertable, continually causing chunks older than 24 hours to be deleted, simply execute the command:
SELECT add_retention_policy('conditions', INTERVAL '24 hours');
To subsequently remove the policy:
The scheduler framework also allows one to view scheduled jobs:
SELECT * FROM timescaledb_information.job_stats;
For more information, please see the API documentation.