Allows you to set a policy by which the system compresses a chunk automatically in the background after it reaches a given age.
Note that compression policies can only be created on hypertables that already
have compression enabled, e.g., via the
ALTER TABLE command
timescaledb.compress and other configuration parameters.
|REGCLASS||Name of the hypertable|
|INTERVAL or INTEGER||The age after which the policy job compresses chunks|
compress_after parameter should be specified differently depending on the type of the time column of the hypertable:
|BOOLEAN||Setting to true causes the command to fail with a warning instead of an error if a compression policy already exists on the hypertable. Defaults to false.|
Add a policy to compress chunks older than 60 days on the 'cpu' hypertable.
SELECT add_compression_policy('cpu', INTERVAL '60d');
Add a compress chunks policy to a hypertable with an integer-based time column:
SELECT add_compression_policy('table_with_bigint_time', BIGINT '600000');
Found an issue on this page?Report an issue!