3 ms·

Yep, partitions are the way to go there.

• awinter-py 4mo ago
  ^ this been exploring clickhouse and while it is definitely not a general purpose DB, for time-series shaped data that can survive some insert latency, the automatic partition-based TTL is very nice and, at least so far, requires zero attention to maintain which I guess is solved by `pg_partman` at the bottom of the post