Measure Hasura/TimescaleDB read performance

HSLdevcom / transitlog

Explore observed public transport and compare with the intended traffic

https://reittiloki.hsl.fi/

Creative Commons Attribution 4.0 International

5 stars 1 forks source link

Measure Hasura/TimescaleDB read performance #11

Open paasovaara opened 5 years ago

paasovaara commented 5 years ago

We want to store at least 3 months, rather 2 years worth of data in TimescaleDB. The amount of data will be roughly 40G/day, 1.2T/month, 15T/year.

making queries to this data is allowed to last seconds. measure performance.

paasovaara commented 5 years ago

initial monitoring done, insert speed is good enough when writing directly to database. read measurements need to be done once the database is larger.