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.

NameTypeDescription
chunk_nameREGCLASSName of the chunk to be compressed
NameTypeDescription
if_not_compressedBOOLEANSetting to true skips chunks that are already compressed, but the operation still succeeds. Defaults to false.
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!