remove_compression_policy

Versions:

remove_compression_policy()
community
Community functions are available under Timescale Community Edition. Click to learn more.

If you need to remove the compression policy. To re-start policy-based compression again you need to re-add the policy.

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

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.

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');

Found an issue on this page?