search

timescale / tsbs

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

provide file in/out support #24

Closed sunsingerus closed 6 years ago

sunsingerus commented 6 years ago

Provide possibility to specify input/output filename for plain text files for all tools:

  1. data generator
  2. query generator
  3. data loader
  4. query runner

New option added: -file /path/to/file (short form) or --file=/path/to/file (long form)

More discussion in this issue

Use-cases:

./tsbs_generate_data -format timescaledb -use-case cpu-only -scale-var 10 -seed 123 -file /tmp/bulk_data/timescaledb
./tsbs_generate_queries -format timescaledb -use-case cpu-only -scale-var 10 -seed 123 -query-type lastpoint -file /tmp/bulk_data/query_timescaledb
./tsbs_load_timescaledb --postgres="sslmode=disable port=5433" --db-name=benchmark --host=127.0.0.1 --user=postgres --workers=1 --file=/tmp/bulk_data/timescaledb_data
./tsbs_run_queries_timescaledb --postgres="sslmode=disable port=5433" --db-name=benchmark --hosts=127.0.0.1 --user=postgres --workers=1 --file=/tmp/bulk_data/timescaledb_query
CLAassistant commented 6 years ago

CLA assistant check
All committers have signed the CLA.

sunsingerus commented 6 years ago

Ooops, test failed, update needed