Continuous aggregates

From real-time dashboards to performance monitoring and historical trend analysis, data aggregation is a must-have for any sort of analytical application. To address this need, Timescale Cloud continuous aggregates precompute and store aggregate data for you. Using PostgreSQL materialized views, continuous aggregates incrementally refresh the aggregation query in the background, so that when you do run it, only the data that has changed needs to be computed, not the entire dataset. This means you always have the latest aggregate data at your fingertips - and spend as little resources on it, as possible.

In this section you:

• Learn about continuous aggregates to understand how it works before you begin using it.
• Create a continuous aggregate and query it.
• Create a continuous aggregate on top of another continuous aggregate.
• Add refresh policies to an existing continuous aggregate.
• Manage time in your continuous aggregates.
• Drop data from your continuous aggregates.
• Manage materialized hypertables.
• Use real-time aggregates.
• Use compression with continuous aggregates.
• Migrate your continuous aggregates from old to new format. Continuous aggregates created in Timescale 2.7 and later are in the new format, unless explicitly created in the old format.
• Troubleshoot continuous aggregates.