When you create a $HYPERTABLE using CREATE TABLE ... WITH ..., the default partitioning
column is automatically the first column with a timestamp data type. Also, $TIMESCALE_DB creates a
columnstore policy that automatically converts your data to the $COLUMNSTORE, after an interval equal to the value of the chunk_interval, defined through compress_after in the policy. This columnar format enables fast scanning and
aggregation, optimizing performance for analytical workloads while also saving significant storage space. In the
$COLUMNSTORE conversion, $HYPERTABLE chunks are compressed by up to 98%, and organized for efficient, large-scale queries.
You can customize this policy later using alter_job. However, to change after or
created_before, the compression settings, or the $HYPERTABLE the policy is acting on, you must
remove the columnstore policy and add a new one.
You can also manually convert chunks in a $HYPERTABLE to the $COLUMNSTORE.