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.
Keywords
Found an issue on this page?Report an issue or Edit this page in GitHub.