Re:Show HN: Query 1.6B rows in milliseconds, live
by bluestreak on Wednesday June 24, 2020 @11:45AM
(#23629288)
the use of where clause right now turns off vectorization completely is falls back on simple single threaded execution. This is the reason why the query is slow right now. We are going to vectorize 'where' really soon.
I'm curios why the following query doesn't finish in tens of seconds:
The same query is executed in a hundred of milliseconds on ClickHouse running on the same hardware (~20 vCPUs).