Wondering if there is some kind of config where we can have clickhouse just delete data if disk is close to full instead of needing to oversize the disk to fit some number of days which can fluctuate based on service usage. This way you can then tell how many days you start to store (as it would be less and less days if load increases) and can increase size of disk after to accommodate (usually easier to increase a size of the disk than reduce).

I don’t think there is a such feature. I think the possible ways to delete the data are to set TTL/ drop partition / TRUNCATE table/ ALTER.

I think you should configure s3 as cold storage and set

move_factor

. https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/mergetree/#table_engine-mergetree-multiple-volumes_configure

I think this doesn’t delete the data. He appeared to have configured move_factor (earlier message), and there is some issue with it.

ohkk

It could be misconfiguration, i think ill try with explicit access keys if i have time