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

NameDescription
hypertable(REGCLASS) Name of the hypertable the policy should be removed from.

Optional Arguments

NameDescription
if_exists(BOOLEAN) Setting 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');