The compress_chunk function is used to compress (or recompress, if necessary) 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.

You can also compress chunks by running the job associated with your compression policy. compress_chunk gives you more fine-grained control by allowing you to target a specific chunk that needs compressing.

Tip

You can get a list of chunks belonging to a hypertable using the show_chunks function.

NameTypeDescription
chunk_nameREGCLASSName of the chunk to be compressed
NameTypeDescription
if_not_compressedBOOLEANDisabling this will make the function error out on chunks that are already compressed. Defaults to true.
ColumnDescription
compress_chunk(REGCLASS) Name of the chunk that was compressed

Compress a single chunk.

SELECT compress_chunk('_timescaledb_internal._hyper_1_2_chunk');

Keywords

Found an issue on this page?Report an issue or Edit this page in GitHub.