Timescale Documentation | Create a continuous aggregate

docs.timescale.com · 1,523 words · saved by 1 readers

Create a continuous aggregate in your Timescale Cloud service and make sure you always have the latest aggregated data for your analytical queries

Create a continuous aggregate | Tiger Data Docs Skip to content Copy Markdown Open in Claude Open in ChatGPT Open in Cursor Copy Markdown View as Markdown Create a continuous aggregate Create a continuous aggregate and make sure you always have the latest aggregated data for your analytical queries A continuous aggregate stores precomputed rollups so analytical queries avoid rescanning all raw rows. You create the materialized view first, then wire up refresh (policy or manual). You can build on a hypertable or stack another continuous aggregate, and you can define more than one continuous agg

Timescale Documentation | Create a continuous aggregate

related reading