Yep, partitions are the way to go there.

^ 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