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.
Found an issue on this page?Report an issue!