`select distinct pickup_latitude, count(\*) from trips` takes 241.37s. But some ... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

lykr0n on June 23, 2020 | parent | context | favorite | on: Show HN: Query 1.6B rows in milliseconds, live

`select distinct pickup_latitude, count(*) from trips` takes 241.37s.

But some of the more top level queries are quite fast.

bluestreak on June 23, 2020 [–]

Thanks, not all queries are optimal yet. We are going to get there.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact