3 ms·
The last time this was posted a few commenters mentioned using PostGIS instead of Uber rolling this themselves. If anyone's used PostGIS with a similar level o
by jdcarr 9y ago
The last time this was posted a few commenters mentioned using PostGIS instead of Uber rolling this themselves.
If anyone's used PostGIS with a similar level of traffic/latency requirements could you comment on your experience?
- bpicolo 9y agoIt's interesting - their use case requires consistent background refresh, which might make postGIS less optimal, but unsure what rate they were doing it at. Query-wise, PostGIS should be able to use geohashes which can do these lookups in O(1) time (S2 geometry would be similar). That said, indexing scales terrible with geohashing/S2 at high granularity levels, though they wouldn't need something particularly granular for this (seems fine to be off by tens or hundreds of meters)
- afeezaziz 9y agoI am learning PostGIS and PgRouting but there is not many tutorials/resources out there. Do you have any recommendations?
- SOLAR_FIELDS 9y agoSearch Anita Graser, she has some good introductory materials.
- afeezaziz 9y agoThanks!