remove_compression_policy()
communityCommunity functions are available under Timescale Community Edition. Click to learn more.Tiger Cloud: Performance, Scale, Enterprise
Self-hosted products
MST
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.
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');
| Name | Type | Description |
|---|---|---|
hypertable | REGCLASS | Name of the hypertable or continuous aggregate the policy should be removed from |
| 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. |
Keywords
Found an issue on this page?Report an issue
or Edit this page in GitHub.