Old API since v2.18.0. Replaced by convert_to_rowstore().
Before decompressing s, stop any compression policy on the you are decompressing. You can use
SELECT alter_job(JOB_ID, scheduled => false); to prevent scheduled execution.
Samples
Decompress a single :
SELECT decompress_chunk('_timescaledb_internal._hyper_2_2_chunk');
metrics:
SELECT decompress_chunk(c, true) FROM show_chunks('metrics') c;
Arguments
| Name | Type | Default | Required | Description |
|---|
chunk_name | REGCLASS | - | ✔ | Name of the to be decompressed. |
if_compressed | BOOLEAN | true | - | Disabling this will make the function error out on s that are not compressed. |
Returns
| Column | Type | Description |
|---|
decompress_chunk | REGCLASS | Name of the that was decompressed. |
