Hello,
I've migrated to TimescaleDB a few months ago, it works well since, but db size has been increasing constantly and significantly(from 500GB to 2TB).
The number of host increased during that time, but not so much.
I've checked tables size and it seems that most of it are history:
I've tried to change the housekeeping setting(compression is enabled from start for minimum 7 days), but it didn't affect db size mostly.
Any advise what to check?
I've migrated to TimescaleDB a few months ago, it works well since, but db size has been increasing constantly and significantly(from 500GB to 2TB).
The number of host increased during that time, but not so much.
I've checked tables size and it seems that most of it are history:
hypertable_name | hypertable_size
-----------------+-----------------
history | 536148967424
history_uint | 916502667264I;
history_str | 246494855168
history_text | 206778114048
history_log | 29433192448
trends | 13386760192
trends_uint | 20786864128
-----------------+-----------------
history | 536148967424
history_uint | 916502667264I;
history_str | 246494855168
history_text | 206778114048
history_log | 29433192448
trends | 13386760192
trends_uint | 20786864128
Any advise what to check?