Just a heads up - I tried this random query: select * from trips where pickup_la... | Hacker News

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

login

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

Just a heads up - I tried this random query:

  select * from trips where pickup_latitude < -74 order by pickup_longitude desc limit 10;

Didn't get a result set. The little box in the upper right hand corner stated "Maximum number of pages (16) breached in MemoryPages"

bluestreak on June 23, 2020 [–]

Ordering would be memory intensive. There are configurable artificial limits in place on this demo instance. This is just because database takes internet traffic directly. In any other settings these limits can be relaxed, which is default behaviour anyway.

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