ALTER MATERIALIZED VIEW (Continuous Aggregate)
CommunityCommunity functions are available under Timescale Community Edition. Click to learn more.Timescale Cloud: Performance, Scale, Enterprise
Self-hosted products
MST
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 viewRENAME [COLUMN]clause to rename the continuous aggregate columnSET SCHEMAclause to set the new schema for the continuous aggregate viewSET TABLESPACEclause to move the materialization of the continuous aggregate view to the new tablespaceOWNER TOclause to set new owner for the continuous aggregate view
ALTER MATERIALIZED VIEW <view_name> SET ( timescaledb.<option> = <value> [, ... ] )
| Name | Type | Description |
|---|---|---|
<view_name> | TEXT | Name (optionally schema-qualified) of continuous aggregate view to be created. |
| Name | Type | Description |
|---|---|---|
timescaledb.materialized_only | TEXT | Enable and disable real-time aggregation |
timescaledb.compress | TEXT | Enable and disable compression |
timescaledb.compress_orderby | TEXT | Order used by compression, specified in the same way as the ORDER BY clause in a SELECT query. The default is the descending order of the hypertable's time column. |
timescaledb.compress_segmentby | TEXT | Column list on which to key the compressed segments. An identifier representing the source of the data such as device_id or tags_id is usually a good candidate. The default is no segment by columns. |
timescaledb.compress_chunk_time_interval | TEXT | EXPERIMENTAL: set compressed chunk time interval used to roll compressed chunks into. This parameter compresses every chunk, and then merges it into a previous adjacent chunk if possible, to reduce the total number of chunks in the hypertable. It should be set to a multiple of the current chunk interval. This option can be changed independently of other compression settings and does not require the timescaledb.compress argument. |
timescaledb.enable_cagg_window_functions | BOOLEAN | EXPERIMENTAL: enable window functions on continuous aggregates. Support is experimental, as there is a risk of data inconsistency if the user is not careful. For example, in backfill scenarios, buckets could be missed. |
To disable real-time aggregates for a continuous aggregate:
ALTER MATERIALIZED VIEW contagg_view SET (timescaledb.materialized_only);
To enable compression for a continuous aggregate:
ALTER MATERIALIZED VIEW contagg_view SET (timescaledb.compress);
To rename a column for a continuous aggregate:
ALTER MATERIALIZED VIEW contagg_view RENAME COLUMN old_name TO new_name;
The only options that currently can be modified with ALTER
MATERIALIZED VIEW are materialized_only and compress. The other options
continuous and create_group_indexes can only be set when creating
the continuous aggregate.
Keywords
Found an issue on this page?Report an issue or Edit this page in GitHub.