search

timescale / tsbs

Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data
MIT License
1.26k stars 297 forks source link

Continuous aggregates #203

Closed VassilisDrouzas closed 2 years ago

VassilisDrouzas commented 2 years ago

Hello,

I just wanted to ask if there is the capability to benchmark queries by using continuous aggregates for TimescaleDB (or continuous queries, for InfluxDB).Is it supported by TSBS?

ryanbooz commented 2 years ago

At this time there is no functionality to create continuous aggregates as part of the benchmark suite. It's something we've discussed for some time haven't implemented.

Part of the challenge is that all "continuous" features like this are intended for longer-term continuous data ingestion. While we could show on most systems that and aggregate query does improve significantly with pre-aggregated data, the frequency at which the aggregate would be updated in real-life usage differs between each system. That would make it difficult to benchmark during the time of a test.