Versions:

alter_policies()

Alter refresh, compression, or data retention policies on a continuous aggregate. The altered compression and retention policies apply to the continuous aggregate, not to the original hypertable.

timescaledb_experimental.alter_policies(
relation REGCLASS,
if_exists BOOL = false,
refresh_start_offset "any" = NULL,
refresh_end_offset "any" = NULL,
compress_after "any" = NULL,
drop_after "any" = NULL
) RETURNS BOOL

warning

Experimental features could have bugs. They might not be backwards compatible, and could be removed in future releases. Use these features at your own risk, and do not use any experimental features in production.

Required arguments

NameTypeDescription
relationREGCLASSThe continuous aggregate that you want to alter policies for

Optional arguments

NameTypeDescription
if_not_existsBOOLWhen true, prints a warning instead of erroring if the policy doesn't exist. Defaults to false.
refresh_start_offsetINTERVAL or INTEGERThe start of the continuous aggregate refresh window, expressed as an offset from the policy run time.
refresh_end_offsetINTERVAL or INTEGERThe end of the continuous aggregate refresh window, expressed as an offset from the policy run time. Must be greater than refresh_start_offset.
compress_afterINTERVAL or INTEGERContinuous aggregate chunks are compressed if they exclusively contain data older than this interval.
drop_afterINTERVAL or INTEGERContinuous aggregate chunks are dropped if they exclusively contain data older than this interval.

For arguments that could be either an INTERVAL or an INTEGER, use an INTERVAL if your time bucket is based on timestamps. Use an INTEGER if your time bucket is based on integers.

Returns

Returns true if successful.

Sample usage

Given a continuous aggregate named example_continuous_aggregate with an existing compression policy, alter the compression policy to compress data older than 16 days:

SELECT timescaledb_experimental.alter_policies(
'continuous_agg_max_mat_date',
compress_after => '16 days'::interval
);

Found an issue on this page?

Report an issue!

Keywords

Related Content