[jdcarr]

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]

It'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]

I am learning PostGIS and PgRouting but there is not many tutorials/resources out there. Do you have any recommendations?

[SOLAR_FIELDS]

Search Anita Graser, she has some good introductory materials.

[afeezaziz]

Thanks!