remove_compression_policy()

Remove a compression policy from a hypertable

Old API since v2.18.0. Superseded by remove_columnstore_policy(). However, compression APIs are still supported, you do not need to migrate to the hypercore APIs.

If you need to remove the compression policy. To restart policy-based compression you need to add the policy again. To view the policies that already exist, see informational views.

Samples

Remove the compression policy from the ‘cpu’ table:

SELECT remove_compression_policy('cpu');

Remove the compression policy from the ‘cpu_weekly’ :

SELECT remove_compression_policy('cpu_weekly');

Arguments

The syntax is:

SELECT remove_compression_policy(
    hypertable = '<hypertable_name>',
    if_exists = true | false
);

Name	Type	Default	Required	Description
hypertable	REGCLASS	-	✔	Name of the or the policy should be removed from
if_exists	BOOLEAN	false	-	Setting to true causes the command to fail with a notice instead of an error if a compression policy does not exist on the .