News for hackers. Stuff that matters.
Re:Show HN: Query 1.6B rows in milliseconds, live by valyala on Wednesday June 24, 2020 @10:40AM (#23628369)
Great demo!

I'm curios why the following query doesn't finish in tens of seconds:

    select sum(passenger_count) from trips where passenger_count=1
The same query is executed in a hundred of milliseconds on ClickHouse running on the same hardware (~20 vCPUs).
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.