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
COMPRESS TIMESERIES
Function
Used to compress a time-series table or a chunkgroup within a time-series table.
Precautions
- The current version does not support re-writing data to the compressed chunkgroup
- Not specifying the Partition parameter means that compression is performed on all chunkgroups of the time-series table; specifying Partition will perform compression on the specified chunkgroup
Syntax Format
COMPRESS TIMESERIES table_name [ PARTITION chunkgroupname ]Examples
Uqbar=# COMPRESS TIMESERIES weather PARTITION chunkgroup_1;
COMPRESSED
Uqbar=# COMPRESS TIMESERIES weather;
COMPRESSED