v2.0
- About Uqbar
- Release Note
- Uqbar Installation
- Uqbar Management
- Data Retention Policy
- Time-Series Table Management
- Time-Series Data Write
- Data Compression
- Data Deletion
- Data Query
- Continuous Aggregation
- Time-Series Views
- Cluster Management
- Backup and Restoration
- Security
- GUC Parameters
- SQL Syntax
- Third Party Tools Support
- Glossary
Continuous Aggregation
Continuous Aggregation is used to pre-compute and aggregate data. The Continuous Aggregation feature generates aggregation results on the database by defining and scheduling queries that run periodically and store them in a time-series table.
The main roles of continuous aggregation include:
- Real-time Aggregation: By calculating the aggregation results in the background, the query can immediately obtain pre-calculated aggregated data, thus eliminating the need for full-volume computation for each query, greatly improving query performance and reducing query response time.
- Data downsampling: Continuous aggregation can downsample high-resolution time series data into lower resolution aggregated data. By defining appropriate time intervals and aggregation functions, the frequency of data can be reduced, reducing storage costs and improving query efficiency.
- Data summary: By selecting appropriate aggregation functions, such as SUM, AVG, MIN, MAX, etc., the summary information of the data can be generated. These pre-calculated summary information is useful for generating reports, or quickly retrieving aggregated data, and eliminates the need to perform complex calculations.
Create Continuous Aggregation
For details, please refer to CREATE CONTINUOUS AGGREGATION.
Alter Continuous Aggregation
For details, please refer to ALTER CONTINUOUS AGGREGATION.
Drop Continuous Aggregation
For details, please refer to DROP CONTINUOUS AGGREGATION.