Create a policy to drop chunks older than a given interval of a particular hypertable or continuous aggregate on a schedule in the background. (See drop_chunks). This implements a data retention policy and will remove data on a schedule. Only one retention policy may exist per hypertable.
|REGCLASS||Name of the hypertable or continuous aggregate to create the policy for.|
|INTERVAL or INTEGER||Chunks fully older than this interval when the policy is run will be dropped|
drop_after parameter should be specified differently depending on the
type of the time column of the hypertable:
|BOOLEAN||Set to true to avoid throwing an error if the drop_chunks_policy already exists. A notice is issued instead. Defaults to false.|
|INTEGER||TimescaleDB background job id created to implement this policy|
Create a data retention policy to discard chunks greater than 6 months old:
SELECT add_retention_policy('conditions', INTERVAL '6 months');
Create a data retention policy with an integer-based time column:
SELECT add_retention_policy('conditions', BIGINT '600000');
Found an issue on this page?Report an issue!