compress_chunk() Community

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

NameDescription
chunk_name(REGCLASS) Name of the chunk to be compressed

Optional Arguments

NameDescription
if_not_compressed(BOOLEAN) Setting to true will skip chunks that are already compressed. Defaults to false.

Sample Usage

Compress a single chunk.

  1. SELECT compress_chunk('_timescaledb_internal._hyper_1_2_chunk');