Time-series data is associated with specific points in time and is often deleted after a defined period. In ScyllaDB, this lifecycle makes time-windowed compaction a natural fit. section 8.4.1
Time-series data influences compaction choices:
- Use TimeWindowCompactionStrategy (TWCS) when data is time-based or has a stable time to live. section 8.4.1
- TWCS sorts data into time windows, applies size-tiered compaction within each window, and compacts completed windows into separate SSTables. section 8.4.1
- Set the compaction strategy as a table property or change it with ALTER TABLE. section 8.4.1
Figure 8.18 TWCS is only used with time series data, dividing the data into windows and compacting it together when the window expires.
The figure shows how TWCS divides time-series data into windows and compacts each window when it expires. section 8.4.1








