ALTER MATERIALIZED VIEW statement can be used to modify some of the
WITH clause options for the continuous aggregate view.
ALTER MATERIALIZED VIEW statement also supports the following
PostgreSQL clauses on the
continuous aggregate view:
RENAME TOclause to rename the continuous aggregate view;
SET SCHEMAclause to set the new schema for the continuous aggregate view;
SET TABLESPACEclause to move the materialization of the continuous aggregate view to the new tablespace;
OWNER TOclause to set new owner for the continuous aggregate view.
ALTER MATERIALIZED VIEW <view_name> SET ( timescaledb.<option> = <value> [, ... ] )
|TEXT||Name (optionally schema-qualified) of continuous aggregate view to be created.|
To disable real-time aggregates for a continuous aggregate:
ALTER MATERIALIZED VIEW contagg_view SET (timescaledb.materialized_only = true);
The only option that currently can be modified with
MATERIALIZED VIEW is
materialized_only. The other options
create_group_indexes can only be set when creating
the continuous aggregate.
Found an issue on this page?Report an issue!