If you need to modify or add data to a chunk that has already been compressed, you need to decompress the chunk first. This is especially useful for backfilling old data.
Before decompressing chunks, stop any compression policy on the hypertable you are decompressing. You can use
SELECT alter_job(JOB_ID, scheduled => false); to prevent scheduled execution. When you finish backfilling or updating data, turn the policy back on. The database automatically recompresses your chunks in the next scheduled job.
|Name of the chunk to be decompressed.|
|Setting to true skips chunks that are not compressed. Defaults to false.|
Decompress a single chunk:
Decompress all compressed chunks in a hypertable named
SELECT decompress_chunk(c, true) FROM show_chunks('metrics') c;
Found an issue on this page?Report an issue!