Selecting chunks to compress

1. At the psql prompt, select all chunks in the table example that are older than three days:

2. This returns a list of chunks. Take note of the chunks' names:

||show_chunks| |---|---| |1|_timescaledb_internal_hyper_1_2_chunk| |2|_timescaledb_internal_hyper_1_3_chunk|

When you are happy with the list of chunks, you can use the chunk names to manually compress each one.