3 ms·

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

Also this queries are different? order by "time" vs order by "created_at" https://github.com/timescale/tsbs/blob/a045665d9c94426bbc4055c5b88246bd64cbd794/cmd/tsbs_generate_queries/databases/clickhouse/devops.go#L277 https://github.com/timescale/tsbs/blob/a045665d9c94426bbc405... https://github.com/timescale/tsbs/blob/a045665d9c94426bbc4055c5b88246bd64cbd794/cmd/tsbs_generate_queries/databases/timescaledb/devops.go#L225 https://github.com/timescale/tsbs/blob/a045665d9c94426bbc405...

ryanbooz 5y ago
We were using tags, so that "else" block isn't the one being used for ClickHouse. Regardless, the table that is created (by the community and verified by former CH engineers) orders by created_at, not time and so that query should be the "fastest" the distinct possible.