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][postgres-alterview] 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!