Re:No, QuestDB is not Faster than ClickHouse
by tomhallett on Thursday June 16, 2022 @02:23PM
(#31769284)
I was curious to hear more details about this statement - "while QuestDB utilizes its full indexing strategy to read just a tiny fraction of the actual data". Did QuestDB create indexes in their QuestDB benchmark but just not mention it? Are there geoindexes which are automatically enabled which do help (but are of less value in the general sense from Clickhouse' perspective)?
[ Parent
| on HN ]
Re:No, QuestDB is not Faster than ClickHouse
by twoodfin on Thursday June 16, 2022 @02:42PM
(#31769461)
I don't know how QuestDB is implemented in any detail, but this statement struck me as confused. My understanding is that for this query, QuestDB is performing a full scan of the relevant columns, and the point of the blog post was how fast their JIT engine for filtering makes this.