remove_columnstore_policy()

Remove a columnstore policy from a hypertable

Since 2.18.0

remove_columnstore_policy() replaces remove_compression_policy(), deprecated in 2.18.0. The parameters are the same.

Remove a policy from a or .

To restart automatic migration to the , you need to call add_columnstore_policy again.

Samples

You see the policies in the informational views.

• Remove the policy from the cpu table:

  CALL remove_columnstore_policy('cpu');
  

• Remove the policy from the cpu_weekly :

  CALL remove_columnstore_policy('cpu_weekly');
  

Arguments

The syntax is:

CALL remove_columnstore_policy(
    hypertable = '<hypertable_name>',
    if_exists = true | false
);

Name	Type	Default	Required	Description
hypertable	REGCLASS	-	✔	Name of the or to remove the policy from
if_exists	BOOLEAN	false	✖	Set to true so this job fails with a warning rather than an error if a policy does not exist on hypertable

Returns

This function returns void.