remove_compression_policy()

community

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

Required Arguments

NameTypeDescription
hypertableREGCLASSName of the hypertable the policy should be removed from.

Optional Arguments

NameTypeDescription
if_existsBOOLEANSetting to true will cause 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:

  1. SELECT remove_compression_policy('cpu');