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

NameTypeDescription
hypertableREGCLASSName of the hypertable or continuous aggregate the policy should be removed from

Optional arguments

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