timescale/tsbs on Hacker News

AFAIK https://github.com/timescale/tsbs is based on artificial data and I would recommend running benchmarks and comparisons on real data from node_exporter, like https://github.com/VictoriaMetrics/prometheus-benchmark .

comment by dengolius · 2024-05-24 · in pg_timeseries: Open-source time-series extension for PostgreSQL

…TSBS was a bottleneck in some tests. Sadly, the PR with the improvements is still not merged: https://github.com/timescale/tsbs/pull/186 edit: I thought I would link some of the more interesting tests: Since QuestDB supports the Postgres…

comment by jerrinot · 2023-08-17 · in Fuzz testing: the best thing to happen to our application tests

…[5] https://docs.influxdata.com/influxdb/cloud/write-data/best-p... [6] https://github.com/timescale/tsbs [7] https://www.vldb.org/pvldb/vol8/p1816-teller.pdf

comment by nhourcard · 2023-02-22 · in Show HN: QuestDB with Python, Pandas and SQL in a Jupyter notebook – no install

…while QuestDB is built from scratch with Postgres wire compatibility. You can run benchmarks on https://github.com/timescale/tsbs

comment by nhourcard · 2023-02-21 · in Show HN: QuestDB with Python, Pandas and SQL in a Jupyter notebook – no install

This table schema: https://github.com/timescale/tsbs/blob/bcc00137d72d889e6059e... ...seems like a quite odd way to store time-series in ClickHouse. If I understood that code correctly (and I am really not sure), they partition their data…

comment by untitaker_ · 2022-06-02 · in 4Bn rows/sec query benchmark: ClickHouse vs. QuestDB vs. Timescale

…benchmark. We'd love to get your feedback! [1]: https://news.ycombinator.com/item?id=27411307 [2]: https://github.com/timescale/tsbs

comment by bluestreak · 2022-06-01 · in 4Bn rows/sec query benchmark: ClickHouse vs. QuestDB vs. Timescale

…Time Series Benchmark Suite, which is open-source and has many vendor-contributed configurations: - https://github.com/timescale/tsbs - https://github.com/timescale/tsbs/blob/master/docs/timestrea...

comment by mfreed · 2022-02-22 · in Timescale raises $110M Series C

…if we all just did that.) [0] https://blog.timescale.com/blog/what-is-clickhouse-how-does-... [1] https://github.com/timescale/tsbs [2] https://twitter.com/p_chhetri/status/1455216425807745025 [3] https://www.timescale.com/careers

comment by akulkarni · 2021-11-03 · in TimescaleDB vs ClickHouse

…post it references[1] is basically the reverse. Are the use cases just that different? ----- 0. https://github.com/timescale/tsbs 1. https://blog.timescale.com/blog/what-is-clickhouse-how-does-...

comment by clickok · 2021-11-03 · in TimescaleDB vs ClickHouse

…it has shortcomings just like TimescaleDB does and we tried to faithfully explore each side. [1]: https://github.com/timescale/tsbs/pull/26

comment by ryanbooz · 2021-10-21 · in Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

…to TSBS for TimescaleDB (as an option to turn on/off) and maybe other DBs could do the same. [1]: https://github.com/timescale/tsbs/pull/26

comment by ryanbooz · 2021-10-21 · in Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

…TimescaleDB co-founder) [0] https://blog.timescale.com/blog/building-columnar-compressio... [1] https://github.com/timescale/tsbs

comment by akulkarni · 2021-10-21 · in Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

You can run tsbs by yourself. Just check the options here: https://github.com/timescale/tsbs/blob/master/docs/clickhous... The blog post benchmarks used `--use-case=cpu-only` case for data ingestion. You can see the table definition here:…

comment by jonatasdp · 2021-10-21 · in Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

(Timescale team member here) We used the Time Series Benchmark Suite for all these tests https://github.com/timescale/tsbs . Also, Ryan (post author) will be giving all the config details in a Twitch stream happening next Wednesday. We'll…

comment by carlotasoto · 2021-10-21 · in Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

Ah so the tests you have used are not the ones in https://github.com/timescale/tsbs ?

comment by rkwasny · 2021-10-21 · in Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

Also this queries are different? order by "time" vs order by "created_at" https://github.com/timescale/tsbs/blob/a045665d9c94426bbc405... https://github.com/timescale/tsbs/blob/a045665d9c94426bbc405...

comment by rkwasny · 2021-10-21 · in Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

There is some creative engineering going here :) have a look: https://github.com/timescale/tsbs/blob/master/scripts/load/l... vs https://github.com/timescale/tsbs/blob/master/scripts/load/l...

comment by rkwasny · 2021-10-21 · in Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

…of PostgreSQL and its vibrant ecosystem. Can't wait to share the details in the coming weeks! [1]: https://github.com/timescale/tsbs

comment by ryanbooz · 2021-09-20 · in ClickHouse, Inc.

…https://news.ycombinator.com/item?id=23616878 [3] https://news.ycombinator.com/item?id=23977183 [4] https://github.com/timescale/tsbs

comment by bluestreak · 2021-05-11 · in Building a new vector based storage model

…all our benchmarks are fully open-source for both repeatability and improvements/contributions: https://github.com/timescale/tsbs/blob/master/docs/mongo.md We also really did spend a lot of time investigating approaches with MongoDB, so…

comment by mfreed · 2021-05-05 · in TimescaleDB raises $40M

…Can someone confirm this? 0 - https://aws.amazon.com/blogs/aws/store-and-access-time-serie... 1 - https://github.com/timescale/tsbs

comment by rubiquity · 2020-12-03 · in TimescaleDB vs. Amazon Timestream

…using the software properly! :-) The SQL that we generate for each database can be examined here ( https://github.com/timescale/tsbs/tree/master/cmd/tsbs_gener... ) and as an open source project, anyone is free to contribute!

comment by ryanbooz · 2020-12-03 · in TimescaleDB vs. Amazon Timestream

…an article directly on the power of the feature? It's hurting their brand reputation a bit. [1] https://github.com/timescale/tsbs

comment by BenoitP · 2020-12-03 · in TimescaleDB vs. Amazon Timestream

This is on the roadmap, we will work on integrating with https://github.com/timescale/tsbs , TSBS has Victoria Metrics support too.

comment by sirffuzzylogik · 2020-07-29 · in Launch HN: QuestDB (YC S20) – Fast open source time series database

…Suite [1]? It currently supports benchmarking 9 databases including TimescaleDB and InfluxDB. [1] https://github.com/timescale/tsbs

comment by avthar · 2020-07-28 · in Launch HN: QuestDB (YC S20) – Fast open source time series database

You can look at what we use in our benchmarking tool https://github.com/timescale/tsbs (results described here https://blog.timescale.com/blog/timescaledb-vs-influxdb-for-... ). Pretty much it's a table with time, value, tags_id. Where the…

comment by cevian · 2020-07-21 · in Monitoring your own infrastructure using Grafana, InfluxDB, and CollectD

…[1] made via Timescale TSBS [2]. [1] https://www.altinity.com/blog/clickhouse-for-time-series [2] https://github.com/timescale/tsbs

comment by hagen1778 · 2020-05-22 · in Multi-node TimescaleDB is now free

Open-source Time-Series Benchmarking Suite: https://github.com/timescale/tsbs InfluxDB: https://blog.timescale.com/blog/what-is-high-cardinality-how... https://blog.timescale.com/blog/timescaledb-vs-influxdb-for-... Cassandra:…

comment by mfreed · 2019-08-21 · in Building a distributed time-series database on PostgreSQL

…[4] https://blog.timescale.com/how-to-store-time-series-data-mon... [5] https://github.com/timescale/tsbs

comment by akulkarni · 2019-05-07 · in Zabbix, Time Series Data and TimescaleDB

…some Postgres people use the lab and are waiting on their decision whether to share publicly. [1]: https://github.com/timescale/tsbs

comment by Rafuino · 2018-11-19 · in FoundationDB 6.0 released, featuring multi-region support

…called Time Series Benchmark Suite (TSBS) here that someone just submitted a PR for Clickhouse: https://github.com/timescale/tsbs/pull/26 There is also this spreadsheet that compares a bunch of different time series databases, including…

comment by RobAtticus · 2018-10-31 · in TimescaleDB 1.0 Is Production Ready

…consider contributing [2]. [1] https://blog.timescale.com/time-series-database-benchmarks-t... [2] https://github.com/timescale/tsbs

comment by leehampton · 2018-08-15 · in TimescaleDB vs. InfluxDB: built differently for time-series data