Create a policy that automatically refreshes a continuous aggregate.
|REGCLASS||The continuous aggregate to add the policy for.|
|INTERVAL or integer||Start of the refresh window as an interval relative to the time when the policy is executed|
|INTERVAL or integer||End of the refresh window as an interval relative to the time when the policy is executed|
|INTERVAL||Interval between refresh executions in wall-clock time.|
start_offset should be greater than
end_offset parameters 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 continuous aggregate policy already exists. A notice is issued instead. Defaults to false.|
|INTEGER||TimescaleDB background job id created to implement this policy|
Add a policy that refreshes the last month once an hour, excluding the latest hour from the aggregate (for performance reasons, it is recommended to exclude buckets that still see lots of writes):
SELECT add_continuous_aggregate_policy('conditions_summary', start_offset => INTERVAL '1 month', end_offset => INTERVAL '1 hour', schedule_interval => INTERVAL '1 hour');
Found an issue on this page?Report an issue!