Hacker News new | ask | show | jobs
by pstuart 21 hours ago
Yep, partitions are the way to go there.
1 comments

^ 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