CODEWITHSUNDEEP
timescaledb
Andy Gotz
Andy Gotz

Reputation: 11

Performance of timescaledb with large datasets

we are considering using timescaledb and we would like to know if it is suited to storing timeseries of arrays of data. One example is we record 350 floats 4 times a second over months. We would then like to extract a few days or weeks of daya. A single entry is 350xfloats = 350x4 bytes = 1.4 kilobytes. A week's worth is 1.4x4x60x60x24x7 = 3.386 gigabytes.

How does timescaledb perform with such queries? Does anyone have experience storing and extracting timeseries datasets like this?

Thanks you for your feedback / suggestions.

Andy

Upvotes: 1

Views: 536

Answers (1)

Sven Klemm
Sven Klemm

Reputation: 436

TimescaleDB allows storing your data values in any format you prefer, the most optimal way to store data depends on your query pattern/requirements. Storing data as an array of floats is possible.

Upvotes: 0

Related Questions