Skip to content

Instantly share code, notes, and snippets.

@kovid-r

kovid-r/tsbs_timescaledb_load.sh

Created August 15, 2021 08:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kovid-r/bc30b912fffe79f2e157c8f00805f717 to your computer and use it in GitHub Desktop.
Save kovid-r/bc30b912fffe79f2e157c8f00805f717 to your computer and use it in GitHub Desktop.
Download ZIP
TSBS TimescaleDB Load with 8 workers.
Raw
tsbs_timescaledb_load.sh
[root@ip-benchmark-instance bin]# ./tsbs_load load timescaledb --config=./config.yaml
Using config file: ./config.yaml
time,per. metric/s,metric total,overall metric/s,per. row/s,row total,overall row/s
1629017066,2008653.66,2.008680E+07,2008653.66,178997.65,1.790000E+06,178997.65
1629017076,1290459.37,3.299140E+07,1649558.78,114999.94,2.940000E+06,146999.00
1629017086,1694639.87,4.993780E+07,1664585.74,150999.99,4.450000E+06,148332.66
1629017096,1458699.71,6.452480E+07,1613114.40,129999.97,5.750000E+06,143749.50
1629017106,1627521.36,8.080000E+07,1615995.79,145000.12,7.200000E+06,143999.62
1629017116,1458724.75,9.538780E+07,1589783.18,129995.08,8.500000E+06,141665.46
1629017126,1357760.59,1.089648E+08,1556638.60,121005.40,9.710000E+06,138714.16
1629017136,1380134.43,1.227662E+08,1534575.52,122999.50,1.094000E+07,136749.82
1629017146,1661374.38,1.393800E+08,1548664.31,147999.50,1.242000E+07,137999.79
1629017156,1694161.18,1.563216E+08,1563213.97,151000.11,1.393000E+07,139299.82
1629017166,1661268.67,1.729342E+08,1572127.98,148000.77,1.541000E+07,140090.81
Summary:
loaded 174528000 metrics in 112.229sec with 8 workers (mean rate 1555107.55 metrics/sec)
loaded 15552000 rows in 112.229sec with 8 workers (mean rate 138573.94 rows/sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment