Re:TimescaleDB vs. InfluxDB: built differently for time-seri...
by zphds on Wednesday August 15, 2018 @07:49PM
(#17770736)
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?
[ Parent
| on HN ]
Re:TimescaleDB vs. InfluxDB: built differently for time-seri...
by bsg75 on Wednesday August 15, 2018 @08:54PM
(#17771054)
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