compress_chunk()
The compress_chunk function is used to compress a specific chunk. This is most often used instead of the add_compression_policy function, when a user wants more control over the scheduling of compression. For most users, we suggest using the policy framework instead.
tip
You can get a list of chunks belonging to a hypertable using the show_chunks
function.
Required arguments
Name | Type | Description |
---|---|---|
chunk_name | REGCLASS | Name of the chunk to be compressed |
Optional arguments
Name | Type | Description |
---|---|---|
if_not_compressed | BOOLEAN | Setting to true skips chunks that are already compressed, but the operation still succeeds. Defaults to false. |
Returns
Column | Description |
---|---|
compress_chunk | (REGCLASS) Name of the chunk that was compressed |
Sample usage
Compress a single chunk.
SELECT compress_chunk('_timescaledb_internal._hyper_1_2_chunk');
当前内容版权归 TimescaleDB 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 TimescaleDB .