Versions:
remove_compression_policy() communityCommunity functions are available under Timescale Community Edition. Click to learn more.
community
Community functions are available under Timescale Community Edition. Click to learn more.
If you need to remove the compression policy. To re-start policy-based compression again you need to re-add the policy.
Required arguments
Name | Type | Description |
---|---|---|
hypertable | REGCLASS | Name of the hypertable or continuous aggregate the policy should be removed from |
Optional arguments
Name | Type | Description |
---|---|---|
if_exists | BOOLEAN | Setting 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!