News for hackers. Stuff that matters.
Re:Zabbix, Time Series Data and TimescaleDB by claytonjy on Tuesday May 07, 2019 @01:12PM (#19851371)
I can't say for sure, but shouldn't insertions be way quicker in Timescale, because the index-changes are limited to the most-recent subtable only, and it's still row-based?

We're considering a move from OpenTSDB to Timescale currently, and something that stands out in Timescale is the wide-table format; we get bundles of metrics at each tick, and having them aligned makes usage easier, and perhaps also saved us some space over having the timestamps repeated per metric.

Re:Zabbix, Time Series Data and TimescaleDB by valyala on Sunday May 12, 2019 @05:24AM (#19890940)
Consider moving to time series database with PromQL support. It is much easier to write typical queries over time series data in PromQL than in SQL or Flux. See https://medium.com/@valyala/promql-tutorial-for-beginners-9a...