TimescaleDB API referenceContinuous aggregates

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 TO clause to rename the continuous aggregate view
  • RENAME [COLUMN] clause to rename the continuous aggregate column
  • SET SCHEMA clause to set the new schema for the continuous aggregate view
  • SET TABLESPACE clause to move the materialization of the continuous aggregate view to the new tablespace
  • OWNER TO clause to set new owner for the continuous aggregate view
ALTER MATERIALIZED VIEW <view_name> SET ( timescaledb.<option> = <value> [, ... ] )
NameTypeDescription
<view_name>TEXTName (optionally schema-qualified) of continuous aggregate view to be created.
NameDescription
timescaledb.materialized_onlyEnable and disable real time aggregation
timescaledb.compressEnable and disable compression
timescaledb.compress_orderbyTEXT
timescaledb.compress_segmentbyTEXT
timescaledb.compress_chunk_time_intervalTEXT

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.