remove_compression_policy.md

api_name	remove_compression_policy()
excerpt	Remove a compression policy from a hypertable
topics	compression jobs
keywords	compression policies remove
tags	delete drop
api	license type community function
products	cloud mst self_hosted

import Deprecated2180 from "versionContent/_partials/_deprecated_2_18_0.mdx";

remove_compression_policy()

Superseded by remove_columnstore_policy(). However, compression APIs are still supported, you do not need to migrate to hypercore.

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' continuous aggregate:

SELECT remove_compression_policy('cpu_weekly');

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.