Convert continuous aggregates to the columnstore

Enable columnstore on a continuous aggregate

To enable the columnstore compression on a continuous aggregate, set timescaledb.enable_columnstore = true when you alter the view:

ALTER MATERIALIZED VIEW <cagg_name> set (timescaledb.enable_columnstore = true,);

Copy

To disable the columnstore compression, set timescaledb.enable_columnstore = false:

Set columnstore policies on the continuous aggregate

Before you set up a columnstore policy on a continuous aggregate, you first set the refresh policy. To prevent refresh policies from failing, you set the columnstore policy interval so that actively refreshed regions are not compressed. For example:

1. Set the refresh policy

   SELECT add_continuous_aggregate_policy('<cagg_name>',
     start_offset => INTERVAL '30 days',
     end_offset => INTERVAL '1 day',
     schedule_interval => INTERVAL '1 hour');

   Copy

2. Set the columnstore policy

   For this refresh policy, the after parameter must be greater than the value of start_offset in the refresh policy:

   CALL add_columnstore_policy('<cagg_name>', after => INTERVAL '45 days');

   Copy