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

Allow some percentage of data to be generated for an older timerange #166

Open ryanbooz opened 3 years ago

ryanbooz commented 3 years ago

In preparation for inserting into compressed hypertables, we would like to allow the generated data to accept a second range of time that randomly inserts records for that time range at a fixes percentage relative to the total rows.

This would typically be done after and initial load of data has been completed and tables have been compressed. We would then generate a second set of data, set create_metric_tables=false, and then insert the additional data.

Looking at the current parameters, maybe something like:

This is just a place to start the discussion.