remove_compression_policy()

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.

Required arguments

Name Type Description
hypertable REGCLASS Name of the hypertable or continuous aggregate the policy should be removed from

Optional arguments

Name Type Description
if_exists BOOLEAN Setting to true causes the command to fail with a notice instead of an error if a compression policy does not exist on the hypertable. Defaults to false.

Sample usage

Remove the compression policy from the ‘cpu’ table:

2. SELECT remove_compression_policy('cpu');

Remove the compression policy from the ‘cpu_weekly’ continuous aggregate:

2. SELECT remove_compression_policy('cpu_weekly');