decompress_chunk()
CommunityCommunity functions are available under Timescale Community Edition. Click to learn more.Tiger Cloud: Performance, Scale, Enterprise, Free
Self-hosted products
MST
Important
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.
Decompress a single chunk:
SELECT decompress_chunk('_timescaledb_internal._hyper_2_2_chunk');
Decompress all compressed chunks in a hypertable named metrics:
SELECT decompress_chunk(c, true) FROM show_chunks('metrics') c;
| Name | Type | Description |
|---|---|---|
chunk_name | REGCLASS | Name of the chunk to be decompressed. |
| Name | Type | Description |
|---|---|---|
if_compressed | BOOLEAN | Disabling this will make the function error out on chunks that are not compressed. Defaults to true. |
| Column | Type | Description |
|---|---|---|
decompress_chunk | REGCLASS | Name of the chunk that was decompressed. |
Keywords
Found an issue on this page?Report an issue
or Edit this page in GitHub.