While the time series change over time, the rate at which they change is not often. The time_series_v4 table has the 1-hour granularity. Today, we continue to write to ClickHouse and let it do the deduplication using the ReplacingMergeTree. We can skip writing the same fingerprint for the one-hour window so that resources spent by ClickHouse are allocated elsewhere.
While the time series change over time, the rate at which they change is not often. The
time_series_v4
table has the 1-hour granularity. Today, we continue to write to ClickHouse and let it do the deduplication using the ReplacingMergeTree. We can skip writing the same fingerprint for the one-hour window so that resources spent by ClickHouse are allocated elsewhere.