Re:TimescaleDB 1.0 Is Production Ready
by zip1234 on Wednesday October 31, 2018 @11:51AM
(#18346750)
How fast is it when it has a TB of data? I realize that this is affected by the machine it is running on, but just curious how long those sample queries in the docs would take to run.
[ Parent
| on HN ]
Re:TimescaleDB 1.0 Is Production Ready
by nevi-me on Wednesday October 31, 2018 @12:47PM
(#18347260)
I spent about 8 months writing data to TSDB. I was sending about 200 vehicle locations per 7-10 seconds for most of the day. I guess around 1 million events per day.
I played around with the data in the first week of setting it up, but then I ignored the feed for months.
When I came back on the 8th month, I couldn't get many/most queries to run in decent time. I didn't diagnose the issue, but I stopped the data stream and archived the database. My data was around 100GB, and I was reading it from a server-grade HDD. (I'll update my answer if I can find more accurate details when I get home).
I don't think it was a TSDB issue, might have been on my side. If I can restore my old data into a fresh DB, I'm going to try TSDB again with the data. I'm doing a Stats degree part time, so it'd be interesting to apply some forecasting knowledge to my dataset.