Continuous aggregates

Continuous aggregates are designed to make queries on very large datasets run faster. Timescale continuous aggregates use PostgreSQL materialized views to continuously and incrementally refresh a query in the background, so that when you run the query, only the data that has changed needs to be computed, not the entire dataset.

• 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.
• 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.