I have a continuous aggregate on a hypertable that has an integer based time. The integer value is not an epoch() but it is a monotonically increasing integer, producing a new value approximately every 15 secs. There are functions that can convert this integer to a timestampz and vice vera.
My question is on how I can add a compression policy to compress everything older than a year.
The examples on the documentation suggest an interval but this I cannot use.
I am using timescaledb 2.15.3
I never tried it, but it seems if the set_integer_now_func will help to allow you to use the integer: