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

Required Arguments

hypertableREGCLASSName of the hypertable the policy should be removed from.

Optional Arguments

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:

SELECT remove_compression_policy('cpu');

Found an issue on this page?

Report an issue!

Related Content