Time-series data can be compressed to reduce the amount of storage required, and increase the speed of some queries. This is a cornerstone feature of Timescale. When new data is added to your database, it is in the form of uncompressed rows. Timescale uses a built-in job scheduler to convert this data to the form of compressed columns. This occurs across chunks of Timescale hypertables.
- Manually compress specific chunks.
- Decompress chunks to manually decompress specific chunks.
- Backfill historical data to insert a batch of data into a compressed chunk.
- Modify schema to modify the table definition for a hypertable with compressed chunks.
- Troubleshoot compression.
Warning
Compression alters data on your disk, so always back up before you start.
Keywords
Found an issue on this page?
Report an issue!