I used to keep all of OnlineOrNot's timeseries data entirely in a hot postgres db with the rest of the relational data. Used to take a few seconds to get a wee

I used to keep all of OnlineOrNot's timeseries data entirely in a hot postgres db with the rest of the relational data. Used to take a few seconds to get a week's uptime data and do some useful analysis. Since moving to Clickhouse I think I can grab a full year's data in around 200ms (probably less if I try optimising it). Still completely blows my mind everyday.