Hacker News new | ask | show | jobs
by zphds 2869 days ago
How does Timescale solve the problem of retention. In InfluxDB, old data is thrown out at every tick as the retention window continuously rolls. In the world of Postgres, wouldn't this mean an explicit cron-like DELETE of rows all the time?
1 comments

I believe that since timescale creates time based partitions, you can expire old data by dropping old chunks: https://docs.timescale.com/v0.11/api#drop_chunks