Insert and modify compressed data

In TimescaleDB 2.11 and later, you can insert data into compressed chunks, and modify data in compressed rows.

Warning

This feature requires PostgreSQL 14 or later

In TimescaleDB 2.11 and later, you can also use UPDATE and DELETE commands to modify existing rows in compressed chunks. This works in a similar way to insert operations, where a small amount of data is decompressed to be able to run the modifications. The system attempts to only decompress data that is necessary, to reduce the amount decompression that is done, but in some cases the modification commands can end up decompressing a large amount of data. This often happens if there are no qualifiers, or if the qualifiers can't be used to filter. You can try and avoid this by using columns for segmentby and orderby, which allows as much data as possible to be filtered out before the decompression and modification operations.