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 or continuous aggregate 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');

Remove the compression policy from the 'cpu_weekly' continuous aggregate:

SELECT remove_compression_policy('cpu_weekly');

Found an issue on this page?

Report an issue!

Related Content