Slower query time compared to PostgreSQL

[sbains]

Take a look at this conversation

Slower query time compared to SQL Server

Hello everyone, My team has the following issue. We currently have a relational database with around 40 million entries - they are all entries from tags (TagId, TagValue, TimeStamp). We decided to move to a TS database to improve performance as the numbers keep going up. After importing the 40m values to Influx, we have tried the following query: SELECT * FROM dump WHERE time > 'some_date' AND TagName = 'tag_name' This query runs 3 times slower in InfluxDB than in SQL Server. I tried a lot o…