Search code examples
compressionclickhousetimescaledb

Where does the column decompression happen in TimescaleDB at query time and how does it affect IOPS?

At query time, does the column decompression in TimescaleDB happen all on disk and we incur the cost of reading all the decompressed data in terms of IOPS ?

If anyone also knows the answer to this for ClickHouse it would be appreciated

Solution

  • ClickHouse stores data in compressed format and thus reads compressed data. Decompression happens during query execution in RAM.